"Find" using VBA

  • Thread starter Thread starter Bob Wickham
  • Start date Start date
B

Bob Wickham

Hello,
I'm trying to use VBA to search to through all sheets of a workbook and find
a specially formatted instance of the value that is in Sheet 1, Cell A4.
For instance, if the value of Sheet 1, Cell A4 is "1001", I need to find
where in the Workbook that value is formatted Bold Italic.
The catch is, the value of A4 changes.
I have had some success using the Macro Recorder if the value of Cell A4 is
fixed but any altering of that code returns an error.
Any help appreciated.

Bob
 
Thanks Dave, works terrific.
Excels "Find" does the job as well but I was having a hard time getting it
to work by clicking a Command Button to run some code. Especially as the
Find criteria changed.
 
You must log in or register to reply here.
Back
Top