View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tommy[_4_] Tommy[_4_] is offline
external usenet poster
 
Posts: 20
Default Delete all cells in range matching certain values

I have a range selected dynamically using this: Range(Cells(4, 3),
Cells(4, 3).End(xlDown)).Select

Within the range is a list of strings.However some of the cells
contain the value "0". I would like to be able to sort through the
selected range and delete the value 0 from the cells containing this
value so that I end up with just a blank, clear cell in its place. The
reason for this is that the range eventually gets sorted for non-empty
cells so I need the 0 removed if present. How would I go about this
using VBA?

Regards,

Tom