How to check if cell is blank, but not empty

[LLL0422]

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]

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

[LLL0422]

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

[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

[LLL0422]

Thank you so much!!

[jolivanes]

Like this?

Please Login or Register  to view this content.

[LLL0422]

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

[oeldere]

NON vba soluition

with an helpcolumn

d1

Please Login or Register  to view this content.

if empty it returns zero (0)

[Fotis1991]

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]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/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