| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - To test for a Blank Sheet
Please show the VBA coding required in order to test for a blank
worksheet as well as a blank chart-sheet. Regards. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel - To test for a Blank Sheet
If WorksheetFunction.CountA(Sheet1.Cells) = 0 Then MsgBox "Worksheet is
blank." Don't know much about charts ... <g -- Vasant "TKT-Tang" wrote in message om... Please show the VBA coding required in order to test for a blank worksheet as well as a blank chart-sheet. Regards. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel - To test for a Blank Sheet
One needs to define blank. There can be shapes on the sheet and no cell
entries. -- Regards, Tom Ogilvy "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... If WorksheetFunction.CountA(Sheet1.Cells) = 0 Then MsgBox "Worksheet is blank." Don't know much about charts ... <g -- Vasant "TKT-Tang" wrote in message om... Please show the VBA coding required in order to test for a blank worksheet as well as a blank chart-sheet. Regards. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel - To test for a Blank Sheet
Good point, Tom ... never even thought of that!
Regards, Vasant. "Tom Ogilvy" wrote in message ... One needs to define blank. There can be shapes on the sheet and no cell entries. -- Regards, Tom Ogilvy "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... If WorksheetFunction.CountA(Sheet1.Cells) = 0 Then MsgBox "Worksheet is blank." Don't know much about charts ... <g -- Vasant "TKT-Tang" wrote in message om... Please show the VBA coding required in order to test for a blank worksheet as well as a blank chart-sheet. Regards. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel - To test for a Blank Sheet
Mr. Vasant Nanavati and Mr. Tom Ogilvy,
Thank you for your illumination. A blank worksheet (for my purpose) is primarily devoid of cell entries ; otherwise, there would be required to test for Shapes and Charts Collections. By extension, there could be (resident already) VBA Coding and UserForms as well. How are the items as given detectable by VBA Coding ? Regards. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel - To test for a Blank Sheet
activesheet.shapes.count = 0
Chartobjects are also shapes. for code, see http://www.cpearson.com/excel/vbe.htm there are no userforms in sheets. -- Regards, Tom Ogilvy "TKT-Tang" wrote in message om... Mr. Vasant Nanavati and Mr. Tom Ogilvy, Thank you for your illumination. A blank worksheet (for my purpose) is primarily devoid of cell entries ; otherwise, there would be required to test for Shapes and Charts Collections. By extension, there could be (resident already) VBA Coding and UserForms as well. How are the items as given detectable by VBA Coding ? Regards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logical Test for blank and then for score | Excel Worksheet Functions | |||
| A logical test in the If function for blank, i.e., If blank? | Excel Worksheet Functions | |||
| Excel blank sheet opening but the sheet has data | Excel Discussion (Misc queries) | |||
| Conditional formatting to test blank text cell | Excel Worksheet Functions | |||
| test for not blank, use value in cell and set as variable | Excel Discussion (Misc queries) | |||
Linear Mode
