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.

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

Best regards


Deepak


---
Message posted from http://www.ExcelForum.com/

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

"Veena" wrote in message
om...
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.

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

In article ,
says...
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.