I have some code and one of the subs contains this line:
It works flawlessly.
However I now want to run this code on a different sheet, namely one called "Invoice". So I changed the code to:
However now when I run it, I get a runtime 424 error, "Object Required".
If I change it to:
again, it works fine.
Can anyone tell me what's going on, and why sometimes you need to use "Worksheets("<name>")" format and sometimes not?
Also posted here: http://www.mrexcel.com/forum/e…ed-error.html#post4324572