| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :-) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :-) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the size of characters in Sheet 1, Sheet2, Sheet 3 | Excel Discussion (Misc queries) | |||
| WHY DOES COPING FROM SHEET TO SHEET INCREASE SIZE DRAMATICALLY? | Excel Discussion (Misc queries) | |||
| Work sheet size relative to screen size | Excel Discussion (Misc queries) | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming | |||
Linear Mode
