[variable] definition

[Veena]

HI,
I am new to Excel - VBA and i guess this would be a very simple doubt.
Can you please tell me what a variable surronded by square brackets mean..
For example [opp_row_count]. Does it refer to some inbuilt variable.
Please advice.

Thanks & Regards,
Veena.

 

[agarwaldvk]

In online help this would normally refer to the argument being optional.
- if this is what you were refering to.

Best regards


Deepak

 

[NickHK]

Veena,
It could that the variable name is actually invalid for VB/VBA, but this
force it's acceptance.
Not sure excatly what you are referring to, but I use in class
module/collection to allow an enumeration with For Each:
e.g. Set NewEnum = mCol.[_NewEnum]
where the underscore would normally be invalid as the first character.

NickHK

 

[Tushar Mehta]

It's a shortcut to the Evaluate method. Search XL VBA help for 'square
bracket' (w/o the quotes). The very first suggested topic is 'Evaluate
Method' That explains the use of square brackets some more.
Personally, I find the technique very limiting and use it very, very
rarely.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions