- Aug 20, 2002
Cheers thanks Tommy. It's always nice to have different ideas so that if this situation occurs for yourself you have a number of ideas from the get go. It will be interesting to see if there was any real benefit of one operation over another rather than, as I suspect, they will be much the same. I think Ponsy is right regarding one operation vs another that it depends largely on how the data is organised and how much data your dealing with as well I suppose.Tommy Bak said:That fits well with your idea about replacing in chunks. If the chuncks are big autofilter has an advantage,
and if the chunks are small search and replace is the winner.
I agree Mike! Personally I would store in a hidden sheet and either read from the range directly or read into an array and work from the array if I needed to do a lot of operations. Shades had already hard coded so I left it that way but I should have mentioned this option.Ekim said:From an administration point of view, maintaining company names in a worksheet may be easier than hard-coding the names in a macro, particularly as you state that company names may be “one word, two words, or in a few cases five words” (hard-coding your 40 company names, and 40 replacement names, would drive me nuts).