Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
**URGENT** Macro to find a Cell
If I have the column row references given on 2 cells in my spreadsheet, I
need a macro to read the contents of the two cells and then select that particular cell. Here is the current code I have: Sub test() Sheets("Revised").Activate ActiveSheet.Cells(1, 2).Select End Sub In the existing code the column/row references are static. Ideally I would like the column/row references to be dependent on what figures are listed in cells A1 & B1, however you cannot simply enter those in 1 & 2's spot or it will error. Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
urgent help!find&press,please | Excel Discussion (Misc queries) | |||
Macro to insert formula using cell reference/text - Urgent | Excel Programming | |||
Find first value in row + add following values (Please, Urgent) | Excel Discussion (Misc queries) | |||
find next? urgent | Excel Programming | |||
URGENT! Find and delete row macro | Excel Programming |