| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Cell based on Variable address
Excel Experts, I have a spreadsheet similar to: A B 1 Symbol Shares 2 DELL 25 3 HWP 4 INTC 5 AMD I have assigned the temporary varaible LastSymbol to Cell A5 The currently selected cell is B1, which contains "Shares" I now want to select cell B5 based on the fact that it is the cell with the same row as the variable LastSymbol and the same column of the current Selection. What is the code to do this? Thanks in advance, Alan -- achidsey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert contents of variable cell address | Excel Discussion (Misc queries) | |||
| can chart title be linked to variable cell address? | Excel Discussion (Misc queries) | |||
| Can the column index in a cell address be made variable? | Excel Discussion (Misc queries) | |||
| How do you select a cell with an "absolute" address with a cursor? | New Users to Excel | |||
| Setting a variable cell address | Excel Discussion (Misc queries) | |||
Threaded Mode
