Call code not working

[IDrinkAlone]

I have

Please Login or Register  to view this content.

in the Sheet 1 (Code) and test is in Module 1 (Code) and refuses to work. If I run test directly it works, if I put a command instead of the Call in the Worksheet_Change macro it works, but will not call test. Do they need to be in the same location?

[romperstomper]

if I put a command instead of the Call in the Worksheet_Change macro it works

That is not possible - you have specified that you do not want an absolute address so the returned string would be "H2" and never "$H$2".

[Whizbang]

Nevermind. romperstomper beat me, and gave a better solution.

[IDrinkAlone]

I have not said I did not want an absolute address, I origninally had H2 and changed to $H$2 based on recommendations on other posts, does not work either way. I want to run test anytime I make a change to H2 in Sheet1.

[romperstomper]

By using Address(0, 0) you have told the code that you want a relative address, so the string returned will be "H2" and never "$H$2". This should work assuming you have a macro called test and you are manually changing the value of H2 on its own:

Please Login or Register  to view this content.

[IDrinkAlone]

Okay, I tried with and without the (0,0) and with and without the $'s, but never the right combination, Works great now, thanks.