Checking for nonblank cells in ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a range, let's call it myRange that's cells B22:B24 in my worksheet.
I need to check that these cells are all not blank before doing something
else. I'm not sure how to write the code to check that all are non-blank.
Any suggestions?

Thanks
 
Ron,

I've gotten several messages indicating this wasn't posted when I first
posted it. That's why there are multiple threads. UGH!

Thanks for the response.

Barb
 
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

Checking for non-blank cells in named range 2
Checking for non blank cells in named range 1
Checking range of cells for entry then checking for total 1
VBA set thick borders around non empty cells in range 0
calculating nonblank cells with conditions 3
Worksheet tab won't update. 2
Problem using Range objects 1
Move multiple values in single Cell To Cells of there own? 3

Back
Top