Empty Cell

[Guest]

What is the character for an empty cell? If I use 0,
this is what I have.

If (Range("A" & n).Value) = 0 Then

I want the 0 to be replaced with an empty cell
character. Thank you.

 

[yogendra joshi]

try using (Range("A" & n).Value) = ""

 

[CB Hamlyn]

If IsEmpty(Range("A" & n).Value) Then
'do stuff
End If

Good Luck
CB

 

[CB Hamlyn]

You could also do this:

If Len(Range("A" & n).Value) = 0 Then

Which might run a bit faster, but I haven't tested both to see.
CB Hamlyn

 

[Tod]

Try

If Len(Range("A" & n).Value) = 0 Then

tod