Thread: In macros, an instruction that will return the position of the Active Cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_483_] Leith Ross[_483_] is offline
external usenet poster
  
Posts: 1
Default In macros, an instruction that will return the position of the Active Cell

Hello Aca,

The following examples should help answer your questions. Reversing the
equations will set the ActiveCell address, column, or row to that value.

The Address: Addx = ActiveCell.Address
The Column: Col = ActiveCell.Column
The Row: Row = ActiveCell.Row

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503527

Reply With QuoteReply With Quote