Change an empty cell back to a blank cell ...

[LarryLev]

I have a spreadsheet with a large expanse of empty cells. However,
because I used a vlookup command and copied out the results as their
values, then returned the results to the same locations, cells that
APPEAR empty do NOT register as blank. Any sugesstions how I can return
the empty cells to blank status without checking each one by hand?

 

[Pops Jackson]

Selection.ClearContents 'Should do the job.

 

[LarryLev]

sorry, but I guess I was not clear. Some cells have data that I want to
retain. I only want the empty cells to revert to blank.

 

[Pops Jackson]

I just did not read your message carefully enough.

This seems to work. Of course, you will need to tailor it to your specs.

Sub findempties()
Range("A2").Select
Do
If ActiveCell <> "" Then
ActiveCell.Offset(0, 1).Activate
Else
ActiveCell.Clear
ActiveCell.Offset(0, 1).Activate
End If
Loop
End Sub