View Single Post
  #3   Report Post  
Old February 10th 19, 07:07 PM posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,027
Default Searching cell with zero value and delete their content

Hi everybody,

I have a range of cells which I'd like to search for the value "0%" (or just
0) and then I'd like to delete all these zero values.

The cell range is M17:AF17

All I want is to delete the zero values in that range.

Thanks


Do you mean you want to hide zero values? Do you know that option canned be
turned off (OptionsViewWindowOptions) so cells with zero values appear empty?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion