Cell Row and Column address
 

In VBA code behind a button, how can I determine the
active cell row and column address?

TIA,
Ron

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

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

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