View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mrs. Robinson[_2_] Mrs. Robinson[_2_] is offline
external usenet poster
 
Posts: 10
Default Delete all non-numerics

I'm in the middle of a macro to extrapolate a row of numbers and then use the
numbers as a basis to extrapolate more information. I'm trying to delete all
the blank cells and cells with text in them, leaving behind only the numbers.
Is this possible? The worksheet from which the column is pulled is
formatted as general.

Thanks,
Mrs. Robinson