MS Excel 2000
I am having trouble recording a macro that will copy the text in a cell, and paste it into the Find box, and then find the text (on a seperate worksheet). The macro Finds the text that is in the cell when I recorded it, but I want it to find was is there at the time that I run the macro.
Thanks