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?

Selection.ClearContents 'Should do the job.
--
Pops Jackson


"LarryLev" wrote:

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?

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 wrote:
Selection.ClearContents 'Should do the job.
--
Pops Jackson


"LarryLev" wrote:

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?

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

--
Pops Jackson


"LarryLev" wrote:

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 wrote:
Selection.ClearContents 'Should do the job.
--
Pops Jackson


"LarryLev" wrote:

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?