| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Cell Contents to Select Worksheet with Same Name as Cell Con | Excel Worksheet Functions | |||
| I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
| How do I select & use contents of first non-blank cell in row? | Excel Worksheet Functions | |||
| Can I select a range based on the cell's contents? | Excel Programming | |||
| Please help! Macro to change cell contents based on cell to the left | Excel Programming | |||
Linear Mode
