View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
5tin@ 5tin@ is offline
external usenet poster
 
Posts: 1
Default Delete rows that do not contain a list of values


Hi all,

Is it possible to use VB to delete rows that do not contain a certain
value. For example if the value in column I did not contain "BOS"
"CARDSAVE" "HSBC" those rows would be deleted?

Any help would be amazing!!

Thanks


--
5tin@
------------------------------------------------------------------------
5tin@'s Profile: http://www.excelforum.com/member.php...o&userid=27499
View this thread: http://www.excelforum.com/showthread...hreadid=470138