select a cell based on A1 contents
 

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

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

select a cell based on A1 contents
 

Thanks Chip.

Was going to use it for the other enquiry from Al on the 24th .
Keep Consistent cell positions on screen across tabs

Since realised that I should look at the active cell coordinates to make it
completely automatic.
I'm not getting there yet.
Maybe you can have a go at that one?
Could be usefull for others.

--
Greetings from New Zealand
Bill K



"Chip Pearson" wrote in message
...
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