View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default Capitalization in Declarations

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