View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
YHT YHT is offline
external usenet poster
 
Posts: 1
Default Empty a cell if the values equal to "IN" , "MC" or "PP"

Hi all,

Could someone tell me how to write a script to empty a cell if the current
cell value is equal to "IN", "MC" or "PP"? I need to search from first cell
in Column B till the last cell in the same column.

Thanks.