Sheet Size
 

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 :-)

Sheet Size
 

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 :-)

Sheet Size
 

Thanks Chip, that's exactly what I was looking for

"Chip Pearson" wrote in message
...
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 :-)