>Check out the UsedRange property of Worksheet. It references a range that >contains only the part of the sheet that's in use.

I looked in your book (Office Automation) before I posted and looked for the above property after your message and, its not in there. I will accept your tip as an apology <bg> for its exclusion from your rather excellent book.

Thanks Tamar, I will look at this right away!

-Gary