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