Excelledsoftware – thanks, I tried your method and it works pretty nifty, especially when you write the code for me!It provides the exact same results as mine, and just like yours, mine also allows you to select any cell you want after highlighting the matched cells.I also work with worksheets of hundreds of thousands of rows, and with a large spreadsheet, you have the potential of having many, many highlighted cells, regardless of the methodology.After all, that’s why you did the routine.
I admire your VBA skills, but there are many things that can be accomplished by us commoners without having to employ such skills.I don’t expect to have you on call to write code for me, so I have created other techniques using the built-in Excel functions.
|