Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining row # of selected cell
I need to determine and then store the row number of the cell that has been
selected in the active workbook. Later, after running some additional code, I need to select the cell in column A using the row number that was stored in the first step. Can someone kindly show me how to do this? Thanks in advance for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining row # of selected cell
Bob,
Try this Sub getrow() myAddress = ActiveCell.Row 'write row number to A1 (Change to suit) Sheets("Sheet1").Cells(1, 1).Value = myAddress 'run some other code 'Get row number from A1 on sheet 1 Cells(Sheets("Sheet1").Cells(1, 1).Value, 1).Select End Sub Mike "Bob" wrote: I need to determine and then store the row number of the cell that has been selected in the active workbook. Later, after running some additional code, I need to select the cell in column A using the row number that was stored in the first step. Can someone kindly show me how to do this? Thanks in advance for the help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining row # of selected cell
Mike - Thanks!
"Mike H" wrote: Bob, Try this Sub getrow() myAddress = ActiveCell.Row 'write row number to A1 (Change to suit) Sheets("Sheet1").Cells(1, 1).Value = myAddress 'run some other code 'Get row number from A1 on sheet 1 Cells(Sheets("Sheet1").Cells(1, 1).Value, 1).Select End Sub Mike "Bob" wrote: I need to determine and then store the row number of the cell that has been selected in the active workbook. Later, after running some additional code, I need to select the cell in column A using the row number that was stored in the first step. Can someone kindly show me how to do this? Thanks in advance for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a problem with determining if a shape is selected. | Excel Programming | |||
Determining Range of selected cell | Excel Programming | |||
Determining if a chart is selected | Charts and Charting in Excel | |||
Determining selected worksheet | Excel Programming | |||
Determining whether selected cell has value or formula? | Excel Programming |