Is the way to get the size of one sheet using macro?
Thanks,


---
Message posted from http://www.ExcelForum.com/

On Tue, 27 Jan 2004 01:51:00 -0600, bookworm98
wrote:

Is the way to get the size of one sheet using macro?
Thanks,

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.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

I want to calculate how many *bytes in one sheet.*
Is there any functions to get the sheet size (like get filesize)?
Thanks


---
Message posted from http://www.ExcelForum.com/

On Tue, 27 Jan 2004 04:08:39 -0600, bookworm98
wrote:

I want to calculate how many *bytes in one sheet.*
Is there any functions to get the sheet size (like get filesize)?
Thanks

I don't believe so, no.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. 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

bookworm98 wrote in message ...
Is the way to get the size of one sheet using macro?
Thanks,


---
Message posted from http://www.ExcelForum.com/