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?