Finding & filling blank cells
See one more response at your other post.
scorpiorc wrote:
I have column D that contains both data and blank cells. I need to find a
way to find the blank cells and fill them with a space. I've tried:
For Each z In Range("D1:D")
If z.Value = IsEmpty("D") Then
z = " "
End If
Next z
but get an error. Any ideas how I can do this?
--
Dave Peterson
|