Phil,
opening JE's file:
I would assume you are supposed to change the number in column X19 for
example and see that the code is correctly updating the appropriate cells?
Then look in the worksheet code module and use the code there in your
workbook.

--------------------

To correct your range problem. First make sure you don't have

Dim range as Range
or have range as an argument to a function.

then go to a general module and put in

Public Range as String

Then select the declaration and delete it.

This should clear up your capitalization problem although I don't think it
is contributing to whatever problem you seem to think you are having.

JE was referring to you changing the subject line in your post.


--
Regards,
Tom Ogilvy
"Phil Hageman" wrote in message
...
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
.