Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It means you've declared a variable named "range". The VBE will
override the type capitalization with the variable one. In general, declaring a variable with a VBA keyword is a bad idea, not only for this reason, but because of the other confusion it can cause the reader. In article , "Phil Hageman" wrote: My understanding is that in declaring variables, if the data type is, say, "Range", with a capital "R", it is recognized as a valid data type in VBA. If, when typing in the lower-case text the "r" does not capitalize, does this mean VBA does not recognize the Dim line with "range" as a valid declaration? If so, what to do about it? Thanks, Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Capitalization | Excel Discussion (Misc queries) | |||
Capitalization | Excel Discussion (Misc queries) | |||
Capitalization? | Excel Worksheet Functions | |||
Capitalization | Excel Discussion (Misc queries) | |||
Strange variable declarations | Excel Programming |