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
 
I want to calculate how many *bytes in one sheet.*
Is there any functions to get the sheet size (like get filesize)?
Thanks
Click to expand...

I don't believe so, no.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

METRO 2039 Revealed 0
Tablet size: I love the 8 inches 1
Excel VBA - Problem with Closing Print Preview 0
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21
Remove Hyperlinks Without Changing background shading 14
Run two macros for two different sheets 11
is there a way to control the sheet name you add 3
Macro to Combine Data from Multiple Sheets with Cell References 4

Back
Top