Can we get the size of a sheet ?

  • Thread starter Thread starter bookworm98
  • Start date Start date
Is the way to get the size of one sheet using macro?
Thanks,
Click to expand...

Not sure what you're getting at there. Every sheet is the same size;
65,536 rows * 256 columns.

If you mean the number of cells in USE, you could use:

ActiveSheet.UsedRange.Cells.Count

Similarly if you want to know the address of the used range:

ActiveSheet.UsedRange.Address

You can then use that address with a Range property to return
information about the used range.

If none of that is what your after, please post again with details.
 
I want to calculate how many *bytes in one sheet.*
Is there any functions to get the sheet size (like get filesize)?
Thanks
 
Hi
Size is too vague. The whole sheets dimensions in cm? points? The used
areas dimensions? The number of cells on the sheet? The number of
cells in the used area? The size of a sheet of A4? Then there is
zooming to think about and....

regards
Paul
 
Back
Top