Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying the active cell
Hi,
I need to find the location of the active cell by column and row. i i(2, 3) I want to run a loop from the active cell onwards, the cell am starting from will always be different. I know i can use th activecell.offset(?, ?). But i only really want to be able to find ou what the active cell row and column are. Thanks in advanc -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying the active cell
Hi Pienpeas,
Dim rw as long, col as long rw = ActiveCell.Row col = ActiveCell.Column --- Regards, Norman "Pienpeas " wrote in message ... Hi, I need to find the location of the active cell by column and row. ie i(2, 3) I want to run a loop from the active cell onwards, the cell i am starting from will always be different. I know i can use the activecell.offset(?, ?). But i only really want to be able to find out what the active cell row and column are. Thanks in advance --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying the active cell
Hi,
Dim Rw, Col Rw = ActiveCell.Row Col = ActiveCell.Column regatds, Don "Pienpeas " wrote in message ... Hi, I need to find the location of the active cell by column and row. ie i(2, 3) I want to run a loop from the active cell onwards, the cell i am starting from will always be different. I know i can use the activecell.offset(?, ?). But i only really want to be able to find out what the active cell row and column are. Thanks in advance --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
Identifying a cell/value in a table | Excel Discussion (Misc queries) | |||
Identifying cursor in active spreedsheet | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |