Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If formula current/expired/blank | Excel Worksheet Functions | |||
Auto insert a blank row above the current row based on a cell val. | Excel Discussion (Misc queries) | |||
Qestion to judge whether the candidate has passed or failed ...... | New Users to Excel | |||
When open document, want date to be current automatically. How? | Excel Discussion (Misc queries) | |||
How can I check a cell for current date and insert it if blank? | New Users to Excel |