Recognizing blank cells in Excel

Try

for j=1 to 5
If Not IsEmpty(Cells(j, 6)) <> "" Then
.....
Endif
Next

Juan Pablo

The suggestion give "Type Mismatch" error ? Any thoughts??? Try

Juan,

Why not use an equivalent of =LEN(A1)>0?

Aladin

I think you could use it, but anyway, i forgot to erase the <> "" part. It should read

If Not IsBlank(Cells(j, 6)) then

I guess using

If Len(Cells(j, 6))> 0 then

should work as well. I like the first one because it's "easier" to understand when you're debugging...

Juan Pablo Juan, Why not use an equivalent of =LEN(A1)>0? Aladin

Here's a slightly different approach

If Application.WorksheetFunction.CountBlank(ActiveCell) = 0 Then
MsgBox "Cell not blank"
Else
MsgBox "Cell is Blank"
End If

The suggestion give "Type Mismatch" error ? Any thoughts??? : Try : for j=1 to 5

If Not IsBlank(Cells(j, 6)) then I guess using If Len(Cells(j, 6))> 0 then should work as well. I like the first one because it's "easier" to understand when you're debugging...

I didn't suggest it in order to help you out. There is no need for that. I knew you'd use the equivalent of ISBLANK. Because of that ephemeral problem of blank vs empty, I thought you might be interested in using of the VBA equivalent of LEN...

Aladin

I know you were, it's cleaner, faster, but a little more "difficult"... thanks (NT)

Re: Len worked where ISEmpty didnot :)

My Excel file does not seem to recognize "Empty"
cells correctly, its origianally imported from a test editor..And Excel'97 - that I use - does not
recognize ISBlank..I don't know WHY???

anyway.. LEN thing worked fine.. and I was able to use it in a couple of other palces as well..

thanks,

-Yogesh

Re: Len worked where ISEmpty didnot :)

Don't know what am i thinking... it's not IsBlank, it should work with IsEmpty... but if you imported them from a text editor maybe excel doesn't recognize the cell as "empty".

Juan Pablo My Excel file does not seem to recognize "Empty"