I have this command to search for in excel but it search for formula (for example =Data!$F15) rather than text that the cell contain ( for example "John")
Code: Select all
LookFor := % Clipboard
if (Row := WB.Range("A:C").Find(LookFor).Row)
Anyone knows how to set parameter to search for the text?
Thank you very much in advance.