Thread: Cell Row and Column address
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronald Roberts Ronald Roberts is offline
external usenet poster
  
Posts: 3
Default 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

Reply With QuoteReply With Quote