Thread: select a cell based on A1 contents
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default select a cell based on A1 contents
Bill,

Range(Range("A1").Value).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Bill Kuunders" wrote in message
...
What would be the code to select or activate a cell referred to
in cell A1.

I.e.
A1 has as value of B29.
How can I instruct via macro to select B29?

Thanks
Bill K






Reply With QuoteReply With Quote