View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steven B Steven B is offline
external usenet poster
 
Posts: 14
Default Clear "Blank" cells

Hello all,

I have found, in a number of my workbooks, ranges that contain cells
that appear to be blank, but excel treats them as though they have
data. When I sort a column ascending, these cells end up at the top of
my list. Selecting and clearing them removes whatever value is hidden
there and they no longer sort to the top of my lists.

I'd like to be able to find them and clear all of them in my workbook
but I can't figure out how to "find" them.

Thoughts?



Steven