normally you'd use
..UsedRange.address

note that usedrange includes first to last cell that contains
either data and/or formatting and/or comments.

you can manually check the "last cell" of a sheet by
pressing CtrlEnd. if it is in an "unexpected" location this is probably
due to accidental or remaining formatting. tons of posts on that.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Paul Ilacqua wrote :

What is the best way to get worksheet dimension for worksheets with
non contiguous rows and columns. The dimensions vary sheet to sheet.

Thanks
Paul