Topics Topics Edit Profile Profile Help/Instructions Help Member List Member List  
Search Last 1|3|7 Days Search Search Tree View Tree View  

VBE - What that "False" means in this...

:: EPE Chat Zone ­:: ­Radio Bygones Message Board :: » EPE Forum Archives 2010 - » Archive through 09 October, 2013 » VBE - What that "False" means in this code? « Previous Next »

  Thread Last Poster Posts Pages Last Post
  ClosedClosed: New threads not accepted on this page        

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

atferrari
Frequent Contributor
Username: atferrari

Post Number: 1431
Registered: 05-2005


Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, 19 September, 2013 - 02:49 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Visual Basic for Excel.

In the worksheet I got those 30 shapes and when I run the macro the all 30 get selected.

What that "False" means here?


Sub Macro17()
'
' Macro17 Macro
' Macro grabada el 17/9/2013 por Agustín

ActiveSheet.Shapes.Range(Array("Oval 1", "Oval 2", "Oval 3", "Oval 4" _
, "Oval 5", "Oval 6", "Oval 7", "Oval 8" _
, "Oval 9", "Oval 10", "Oval 11", "Oval 12" _
, "Oval 13", "Oval 14", "Oval 15", "Oval 16")).Select
ActiveSheet.Shapes.Range(Array("Oval 17", "Oval 18", "Oval 19", "Oval 20" _
, "Oval 21", "Oval 22", "Oval 23", "Oval 24" _
, "Oval 25", "Oval 26", "Oval 27", "Oval 28" _
, "Oval 29", "Oval 30")).Select False
End Sub


I could not make sense of it.
Agustín Tomás - Buenos Aires - Argentina
Top of pagePrevious messageNext messageBottom of page Link to this message

atferrari
Frequent Contributor
Username: atferrari

Post Number: 1432
Registered: 05-2005


Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, 19 September, 2013 - 02:41 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Found the reason.

Meant to extend the previous selection instead of replacing it.

Replace False
Agustín Tomás - Buenos Aires - Argentina

Administration Administration Log Out Log Out   Previous Page Previous Page Next Page Next Page