Used Range Question

A

a

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
 
C

Chip Pearson

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
 
Top