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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aca - 20 Jan 2006 11:12 GMT

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

Reply to this Message

Leith Ross - 20 Jan 2006 22:50 GMT

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

Signature

Leith Ross

Reply to this Message

Ken Johnson - 20 Jan 2006 22:55 GMT

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

Reply to this Message