Use variables for cell ranges?

Posted by Carl on January 24, 2001 11:20 PM

Is there any way to use variables for a cell range, i.e., Range("MyCell10") where MyCell = Column 10 = Row

Posted by Dave Hawley on January 25, 2001 3:56 AM

Hi Carl

Sounds like you are after the INDIRECT function.

=INDIRECT(MyCell10)

Or are you talking VBA ?????

OzGrid Business Applications

Posted by Carl on January 25, 2001 5:06 AM

VBA scripts

Posted by doug on January 26, 2001 12:42 PM

the "Selection.row" and "Selection.column" commands may work, give them a try

Posted by Carl on January 27, 2001 9:10 PM

Thanks I will try them.