I have a question that I have not been able to find an answer to so far by searching forum posts and websites. Can we (should we) replace a search of all cells in a range (e.g. ActiveSheet.UsedRange) with a two-dimensional array (if I understand this correctly)?
Here is the situation:
1) For each cells in a range (in case being all used cells in the activeworksheet), search for a word (e.g. Excel) in the cells string
2) For each instance of the found word, change the formatting for this word (e.g. .characters.font) in the string
3) Loop through the whole string in each cell
4) Loop through all cells in the assigned range
This is slow because it looks at each cell separately and then the next cell then next cell, etc. Can we (should we) put the activeSheet.UsedRange into an array and have excel check each part of the array then write back to Excel?
Your thoughts and opinions are highly appreciated (even if you think I have no idea what I am talking about ).