You can use the UsedRange property to determine the rectangular
range containing data. E.g.,


MsgBox Worksheets("Sheet3").UsedRange.Address



"John Peach" wrote in message
...
Is it possible to find the extents of a sheet without selecting
it ? i.e. how many rows and columns have information in them

Thanks in advnace :-)