Try to search your question here, if you can't find : Ask Any Question Now ?

Run-time error 1004, Unable to get the Search property of the worksheetfunction class

HomeCategory: stackoverflowRun-time error 1004, Unable to get the Search property of the worksheetfunction class
Avatarbhawya asked 2 weeks ago

every time i run the code the error

“run-time error 1004: Unable to get the HLookup property of the worksheetfunction class”

when i do a hlookup in an excel sheet with the same parameters,it works, it returns the value i want to.

Sub lookup()

Dim shift As Integer
Set myrange = Range("A1:AZ8")

shift = Application.WorksheetFunction.HLookup("01:30:00", myrange, 3, False)

End Sub
1 Answers
Best Answer
AvatarArben answered 2 weeks ago
Your Answer

12 + 20 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com