N
Neil Pearce
Dear all,
This is a very basic question but one I know not the answer to...
I am working a spreadsheet created by A.N.Other and it has some Macros. One
of which does not work. It starts...
If Len(Range("A1").Value) + Len(Range("B1").Value) > 0 And _
The cells A1 & B1 are actually on another worksheet to the button that the
macro is attached. What would I have to insert to enable the code to make
reference to A1 & B1 on a worksheet entitled say, "Test"?
Thanking you.
Kind regards,
Neil
This is a very basic question but one I know not the answer to...
I am working a spreadsheet created by A.N.Other and it has some Macros. One
of which does not work. It starts...
If Len(Range("A1").Value) + Len(Range("B1").Value) > 0 And _
The cells A1 & B1 are actually on another worksheet to the button that the
macro is attached. What would I have to insert to enable the code to make
reference to A1 & B1 on a worksheet entitled say, "Test"?
Thanking you.
Kind regards,
Neil