Thread: Empty Cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default 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.
.