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

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

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

Ronnie,
Depends what you define as "blank".

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

NickHK

"Ronnie" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>