Excel - To test for a Blank Sheet

  • Thread starter Thread starter TKT-Tang
  • Start date Start date
T

TKT-Tang

Please show the VBA coding required in order to test for a blank
worksheet as well as a blank chart-sheet.
Regards.
 
If WorksheetFunction.CountA(Sheet1.Cells) = 0 Then MsgBox "Worksheet is
blank."

Don't know much about charts ... <g>
 
One needs to define blank. There can be shapes on the sheet and no cell
entries.
 
Good point, Tom ... never even thought of that!

Regards,

Vasant.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste and remove blanks VBA 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Eliminate blanks while copy row and transpose 11
create a pivot table and chart from a named range 1
Excel VBA help: Text file formatting 19
If Then to delete sheet if B1 blank 2
How to split an excel workbook in code and data 2
Excel How to get the number of days an item was opened from the today's date. 14

Back
Top