check if range is empty

A

abenitez77

Board Regular
Joined
Dec 30, 2004
Messages
149
I want to check if the values in the cells in a range are empty or blank. If a cell has a "" value then I want to consider that as empty or blank. How can i do this?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
You're welcome & thanks for the feedback
 
Upvote 0
You must log in or register to reply here.

Similar threads

edge37
  • Solved
Autonumbering formula that ignores empty cells containing formulas and consider them blank
2
Replies
16
Views
328
Fluff
Fluff
I
  • Solved
If a cell has specific text & another cell is empty then add value to that empty cell
Replies
6
Views
135
ipbr21054
I
T
  • Solved
Search for Cells of certain color and empty
Replies
3
Views
379
TheTiredEngineer
T
F
  • Solved
VBA to move range if cell value is not empty
Replies
5
Views
89
fotodj
F
K
  • Solved
combobox values with validation from adjacent cell
Replies
4
Views
138
kampog
K

Forum statistics

Threads
1,224,820
Messages
6,181,155
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top