Mr. McGimplsey, Could this be the problem in the
12/22 "Tweek" thread? How do I hunt for the problem?
Thanks, Phil
-----Original Message-----
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
.