I want to use the find function in a macro to find a value in field B3 in a database F7:H20. The curser should then end up in the field containing the value. The value in B3 is inputted just before the Macro is executed.
I am using the following code but cannot change the value ff292 during the execution as it is now hard coded in the macro - please for some help
![]()
Cells.find(What:="ff292", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False).Activate
Bookmarks