I have a small problem.I am trying to find a given value which might have multiple entries across sheets.
what i need to do is this:
1.Find the value and highlight the row containing this value across all worksheets.
2.Can I have a dialog box similar to FIND so that I can enter a value and it highlights all matches across worksheets.
3.Is there a way in VBA to map this to a keystroke like CTrl+F for find.
Any help would be highly appreciated
Thanks,
Mrudula
what i need to do is this:
1.Find the value and highlight the row containing this value across all worksheets.
2.Can I have a dialog box similar to FIND so that I can enter a value and it highlights all matches across worksheets.
3.Is there a way in VBA to map this to a keystroke like CTrl+F for find.
Any help would be highly appreciated
Thanks,
Mrudula