Damon,
That should do it or get me close to my range that I need. Thank You.
Paul

"Damon Longworth" wrote in message
...
What do you mean by "worksheet dimensions"? You want the last used row and
last used column?

You can focus on a row or column that always contains data for each
record. Then you can use something similar to:

range("a65536").end(xlup).row
range("iv1").end(xltoleft).column

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Paul Ilacqua" wrote in message
...
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