Thread: Efficient way of finding string and changing cell value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ulfb[_2_] ulfb[_2_] is offline
external usenet poster
  
Posts: 20
Default Efficient way of finding string and changing cell value
As amateur I would appreciate your help:

My sheet has 30 000 rows. In col D I need to find "district", not case
sensitive, beeing part of a longer string. If true, value in col C should be
set to "Dis".

Using VBA, Excel 2003 - how can this be done in shortest possible time?
Filter, Find, Search or ??

Thank you!
Reply With QuoteReply With Quote