how do I judge current document is a blank one?
 

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

how do I judge current document is a blank one?
 

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

how do I judge current document is a blank one?
 

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

how do I judge current document is a blank one?
 

Ronnie,
Depends what you define as "blank".

What about pictures, formats, cell borders, validation, background, VBA
code, cell comments, document properties........

NickHK

"Ronnie" wrote in message
...
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

how do I judge current document is a blank one?
 

blank document means that there is nothing to print
in other word, user can not see something. in excel, when user clicks the
file menu and select the print menu to print current document, if current
document is a blank document, then a dialog will be show up to tell user that
there is nothing to print.
it is a blank document i mean

thanks,
Ronnie Ren


"NickHK" wrote:

Ronnie,
Depends what you define as "blank".

What about pictures, formats, cell borders, validation, background, VBA
code, cell comments, document properties........

NickHK

"Ronnie" wrote in message
...
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