Hi,

I know that this is probably very simple, but I just can't seem to
figure it out.

Would somebody please tell me how I can find out the address of the
first cell in a used range? It can either be in the "watch" window or
through the use of the message box. I'm having a problem with some code
and having this information would help me immensely.

Thanks much in advance,
Anita

Anita,

ActiveSheet.UsedRange(1,1).Address

will return the address of the first cell in the UsedRange.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"a" wrote in message
k.net...
Hi,

I know that this is probably very simple, but I just can't seem
to
figure it out.

Would somebody please tell me how I can find out the address of
the
first cell in a used range? It can either be in the "watch"
window or
through the use of the message box. I'm having a problem with
some code
and having this information would help me immensely.

Thanks much in advance,
Anita

Chip,

Thanks, once again!

Anita

Chip Pearson wrote:

Anita,

ActiveSheet.UsedRange(1,1).Address

will return the address of the first cell in the UsedRange.