Jamie,
ActiveSheet.UsedRange should give you what you need.
Jim Cone
San Francisco, USA

"Jamie" wrote in message
om
I have a spreadsheet that may change in size daily. How can I refer to the
range in VBA? CurrentRegion doesn't work as there may be empty rows or
columns in the range I want to select.
Looking for something that would give me (A1:"bottom right cell")
Thanks for any ideas.
Jamie