| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Row and Column address
In VBA code behind a button, how can I determine the
active cell row and column address? TIA, Ron |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Row and Column address
Assuming active cell is B12
Activecell.address(0,0) will return cell address : B12 Activecell.Row will return row num : 12 Activecell.Column will return column num: 2 HTH -- AP "Ronald Roberts" a écrit dans le message de news: ... In VBA code behind a button, how can I determine the active cell row and column address? TIA, Ron |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Row and Column address
Ardus Petus wrote:
Assuming active cell is B12 Activecell.address(0,0) will return cell address : B12 Activecell.Row will return row num : 12 Activecell.Column will return column num: 2 HTH -- AP "Ronald Roberts" a écrit dans le message de news: ... In VBA code behind a button, how can I determine the active cell row and column address? TIA, Ron Thanks Ron |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Row and Column address
ActiveCell.Row
ActiveCell.Column ActiveCell.Address(0,0) -- Regards, Tom Ogilvy "Ronald Roberts" wrote: In VBA code behind a button, how can I determine the active cell row and column address? TIA, Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find cell address of last cell in a column with text | Excel Worksheet Functions | |||
| How to determine the column letter from Cell address | Excel Worksheet Functions | |||
| If Statment - Active Cell Column Address | Excel Discussion (Misc queries) | |||
| Can the column index in a cell address be made variable? | Excel Programming | |||
| Can the column index in a cell address be made variable? | Excel Discussion (Misc queries) | |||
Hybrid Mode
