Excel Find All
 

I tried to record a macro in Excel that uses the Find All option, but
won't record the parameters used during the find all function.
Book
Sheet
Name
Cell
Value
Formula
Does anyone knows how can I get this in my code?
It would be a time saver.:confused: :confused

--
Message posted from http://www.ExcelForum.com

Excel Find All
 

I think MS has decided not to support Find All in VB in any way. I don't
know why. I think you can probably use FindNext to go through the matches
though so maybe it's not really needed.

--
Jim Rech
Excel MVP