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! *