Bishop
08-17-2016, 04:15 AM
Hi all !
I guess it should be quick : I am looking for tips to handle the "Find" function and especially the "What" part.
Most forums I have been on present the function this way :
Cells.Find(What:="Cat", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate
In my code, I would like to replace "Cat" by the value of a cell. I have tried : Range("A1").Value , "Range("A1").Value" and even using an intermediate string to host the value but it is still bugging.
Thanks to any help guys :)
I guess it should be quick : I am looking for tips to handle the "Find" function and especially the "What" part.
Most forums I have been on present the function this way :
Cells.Find(What:="Cat", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate
In my code, I would like to replace "Cat" by the value of a cell. I have tried : Range("A1").Value , "Range("A1").Value" and even using an intermediate string to host the value but it is still bugging.
Thanks to any help guys :)