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