Macro using find-replace

[TerriDet]

What code do I use to create a macro that will allow me to copy-paste-special value from a formula on another worksheet into the FIND input field in the EDIT-FIND-REPLACE function (from the main menu)?

Thanks.

 

[BrianB]

Hopefully some of the code here will help.

If you really just need to put the info into Edit/Find you just need to do a Find in code without returning any values. All the information you have set is saved in Excel until the next one. (used by .FindNext).

http://www.mrexcel.com/board2/viewtopic.php?t=149439&highlight=