checking if worksheet is blank

J

J.E. McGimpsey

On way:

Dim blank As Boolean
blank = Application.CountA(Sheets("Sheet1").Cells) = 0
 

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

Publisher adding blank page when printing my booklet... 2
Populate a table based on check box status 2
Blank pages 0
VBA Coding Help for Beginner 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Blank Page After Envelope-Label Wizard 5
Missing start up options in Word 0
Word 2007 flash screen upside down and Word2007 cannot be used 0

Top