VBA Excel 'Find' Function
Posted on 2007-04-11
I'm attempting to match the strings in a specific column of worksheet A with strings in a specific column in worksheet B. Each match found results in the entire row being copied into a third worksheet. The number of entries in the column in worksheet A varies, so the loop would continue until whatever the VBA equivalent of EOF would be when readiing from a column. I attempted to record a macro where I used the 'Find'/CTRL-F function. It didn't record anything, so I'm looking for the VBA function that's tied to this action.
As always, any help is greatly appreciated.