VBA - Rolling out to a workbook and finding data
From my macro-enabled workbook, I want to open another workbook, and then use the "find" feature to locate a drug name. Part one, open the workbook works fine, Part two, find the data, was derived from "recording a macro", fails. What am I doing wrong?
'This coding opens the drug list workbook
Path = ThisWorkbook.Path & "\"
Application.Workbooks.Open(Path & "HLDrugList.xlsx").Activate
'This coding asks for input, then finds the drug
Cells.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
I get a error on running "Run time error 1104,Activate method of Range find failed"
Should I be using a UserForm??