View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Big H Big H is offline
external usenet poster
 
Posts: 37
Default Deleting zero's within a range?

Hi there,

I have a range of data showing positive numbers, negative numbers and zeros.
The range can extend down to row 10000 or more. Is it possible to delete all
zero values within the range say B10:AA10000 and just leave the positive and
negative values.

thanks Harry