it work well if there is no character,
but if current document contains chart or picture, usedrange's address is A1
and the cell is also blank, but it is not a blank document
how can I deal with this case?

thanks,
Ronnie Ren

"Patrick Molloy" wrote:

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