VBA Find function [Solved/Closed]

francis-abraham 1 Posts Tuesday January 24, 2017Registration date January 24, 2017 Last seen - Jan 24, 2017 at 03:55 PM - Latest reply: ac3mark 9220 Posts Monday June 3, 2013Registration dateModeratorStatus April 25, 2018 Last seen
- Jan 25, 2017 at 04:53 PM
Hello,
I am writing a macro to find text in the worksheet using the "Find" function.
Entering the text in the "Find what" enter box is of course easy.
My special issue now it that the text that should be found is CHANGING !!!
I thought it should be possible to enter the text that should be searched for in cell A1 and the "Find" function should look at cell A1 what text is entered there and then should use the text entered in cell A1 in the "Find what" enter box.

Can anyone give me an tip how this can be done?

Thank you very much.
See more 

1 reply

ac3mark 9220 Posts Monday June 3, 2013Registration dateModeratorStatus April 25, 2018 Last seen - Jan 25, 2017 at 04:53 PM
0
Helpful
SO, you are asking how to search for a VARIABLE?