Check If range of cells is empty

**jakopak** · 08-28-2015, 03:49 AM

I would like to check for condition whether range rng is empty.
I have following code, but it prints "Not Empty" even though that the cells in the range rng are empty.
Can you please hellp me?

Please Login or Register  to view this content.

**YasserKhalil** · 08-28-2015, 03:57 AM

Try this

Please Login or Register  to view this content.

**jakopak** · 08-28-2015, 04:21 AM

Nice one Yasser. Is it somehow possible to get range of cells which are not empty?

**YasserKhalil** · 08-28-2015, 04:25 AM

Try this

Please Login or Register  to view this content.

**jakopak** · 08-28-2015, 05:07 AM

Wow, you are my Hero. Thank you Yasser.

**YasserKhalil** · 08-28-2015, 05:13 AM

Glad I can help. Thanks for the feedback and for the rep points

Check If range of cells is empty

LinkBack

Thread Tools

Rate This Thread

Display

Check If range of cells is empty

Re: Check If range of cells is empty

Re: Check If range of cells is empty

Re: Check If range of cells is empty

Re: Check If range of cells is empty

Re: Check If range of cells is empty

Thread Information

Users Browsing this Thread

Similar Threads

Check if row in Range is empty?

[SOLVED] Check Value above if different add row if same go to next row in range. If empty go to nex

Empty cells not evaluating as empty - multiple check methods tried

Check for each cell in range if is it empty when user click to some cells

check for non-empty cells outside of a certain range

check for non-empty cells outside of a certain range

[SOLVED] How to check a range of cells is empty?

Bookmarks

Bookmarks

Posting Permissions