Thread: Worksheet Ref.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Pearce Neil Pearce is offline
external usenet poster
 
Posts: 109
Default Worksheet Ref.

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