Empty Cell
 

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.

Empty Cell
 

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

wrote:

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.

Empty Cell
 

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

Good Luck
CB

wrote in message
...
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.

Empty Cell
 

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

wrote in message
...
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.

Empty Cell
 

Try

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

tod

-----Original Message-----
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.
.