Newbie question.. what does [somedata] represent? Constants??

[Guest]

I am relatively new to excel/vba programming..I am tackling my 3rd or so
project.

I've come across some logic in a vba module:

lRows = [LocRows] <-----Whats that?
vStore = [LocNum] <-----What's that??
dRow = [DselRow] <------What's that???


I get the feeling these refers to named constants? But I am looking for
somebody to confirm and tell me how to define one.

THanks.

 

[Bob Phillips]

Alex,

LocRows is a workbook name here, referring to a range on the worksheet, or a
value workbook name (such as where the RefersTo value is not a range, but is
a value).

In the former case, it is transferred to an array, and the latter is
transferred to a variable of that particular type.

[] is a (nasty IMO) shortcut way of referring to a range in VBA, such as
[A1] and can use names as can normal range definitions.

--

HTH

RP
(remove nothere from the email address if mailing direct)