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

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

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

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