In macros, an instruction that will return the position of the Active Cell

In a macro, how can I make it show the position of the Active Cell
(Column/Line).
Or how can I set that position as a Condition; e.g. “If ActiveCell is
B7 Then….”
Or “If ActiveCell belongs to Column G Then….”
Thanks in advance for any help.
ACA


--
aca
------------------------------------------------------------------------
aca's Profile: http://www.msusenet.com/member.php?userid=3856
View this thread: http://www.msusenet.com/t-1873690197

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

Hi aca
>how can I make it show the position of the Active Cell<
MsgBox ActiveCell.Address
MsgBox ActiveCell.Column
MsgBox ActiveCell.Row
>how can I set that position as a Condition; e.g. "If ActiveCell is
B7 Then...." <
If ActiveCell.Address = $B$7 Then ...(be careful with this one, must
have the $'s)
>If ActiveCell belongs to Column G Then...<
If ActiveCell.Column = 7 Then...

Ken Johnson