How to check if cell is blank, but not empty

**LLL0422** · 06-09-2014, 10:40 PM

How can I write code to test if a cell is blank? My code is using "isempty" but I keep type mismatch error because my cells are filled with formulas that make the cells blank. It only works if the cells are truly empty with no formulas.

Thanks!

**protonLeah** · 06-09-2014, 10:59 PM

Try
If Range("A1").Value = "" Then

**LLL0422** · 06-09-2014, 11:18 PM

Thanks! Do you know how that would work in a For Each loop?

**jolivanes** · 06-10-2014, 12:22 AM

Like this?

Sub Check_Me()
    Dim c As Range
    For Each c In Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row)
        If c.Value = "" Then
            c.Select
            MsgBox "Hey look, I selected an empty cell although there might be a formula in it!"
        End If
    Next c
End Sub

**pareshj** · 06-10-2014, 12:14 AM

Hi,

For Each c In Worksheets("Sheet1").Range("A1:D10").Cells
If c.Value = "" Then
'' Do something
End If
Next

Where A1:D10 is the sample range i have taken as an example. Please change it accordingly.

Regards,
Paresh J

**LLL0422** · 06-10-2014, 12:22 AM

Thank you so much!!

**Fotis1991** · 06-10-2014, 02:52 AM

Originally Posted by pareshj

Hi,

For Each c In Worksheets("Sheet1").Range("A1:D10").Cells
If c.Value = "" Then
'' Do something
End If
Next

Where A1:D10 is the sample range i have taken as an example. Please change it accordingly.

Regards,
Paresh J

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

**LLL0422** · 06-10-2014, 12:28 AM

That seems like it'll work as well! Thank you!

**oeldere** · 06-10-2014, 02:34 AM

NON vba soluition

with an helpcolumn

d1

=len(a1)

if empty it returns zero (0)

How to check if cell is blank, but not empty

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to check if cell is blank, but not empty

Re: How to check if cell is blank, but not empty

Re: How to check if cell is blank, but not empty

Re: How to check if cell is blank, but not empty

Re: How to check if cell is blank, but not empty

Re: How to check if cell is blank, but not empty

Re: How to check if cell is blank, but not empty

Re: How to check if cell is blank, but not empty

Re: How to check if cell is blank, but not empty

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to check for an empty cell

color blank cell red if blank or empty and count its occurances

Macro to check for blank cell entry, copy previous value, and check for duplicates

check a cell is empty or not

VB - Empty Cell Check

Bookmarks

Bookmarks

Posting Permissions