Tom and J.E.

I have skinnied down a sample worksheet containing the
complete "Tweek" problem. Can I please send it to you - I
know this is not a difficult coding exercise for you guys,
it's me - I just can't get my points across.

Phil
-----Original Message-----
Working from memory - the trigger columns are as you
say. Thanks for the
correction.

--
Regards,
Tom Ogilvy

"J.E. McGimpsey" wrote in message
news:jemcgimpsey-
...
thanks for the added explanation, Tom.

One minor addition: A manual change in U19 will show up
as a
corresponding change in X19. A change in AM19 will show
up as a
corresponding change in AP19, etc. A change in AD19
will not show up
in AG19, since P11 and V11 are blank.

In article ,
"Tom Ogilvy" wrote:

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.


.