not a safe method, but the usedrange property , if the address is A1 and the
cell is blank. Doesn't work if yuo populate a sheet and then clear it.

you could use the COUNTA function perhaps?

"Ronnie" wrote:

there should be a way to judge whether current document is a blank one or not
but I can not find it
how can i do it?
any help will be appreciated?


thanks,
Ronnie Ren