Range of the ActiveCell

**escelinen** · 08-13-2007, 04:16 AM

I'm sure this must be easy one but I can't find a right way.
So I only want to know what is the "coordinates" of the current ActiveCell.
Is it something like: ActiveCell.xxxxx or how can I get the address of the cell, not the value in the cell. For example "C5".

Thanks already, I'm sure there is some nice way to do this ...

**dominicb** · 08-13-2007, 04:32 AM

Good morning escelinen

How about :

Please Login or Register  to view this content.

HTH

DominicB

**escelinen** · 08-13-2007, 04:42 AM

Thanks, I tried many things but not .address. Thanks a lot !

**corinereyes** · 08-13-2007, 04:46 AM

Hi,

Try running this macro.

Sub CellAddress()
Worksheets("Sheet1").Activate
MsgBox ActiveCell.Address
End Sub

**royUK** · 08-13-2007, 05:17 AM

Originally Posted by corinereyes

Hi,

Try running this macro.

You don't need to activate Sheet1

**corinereyes** · 08-13-2007, 08:14 AM

im using the same code so i just copy and paste, thanks roy.

Range of the ActiveCell

LinkBack

Thread Tools

Rate This Thread

Display

Range of the ActiveCell

Yes

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions