TheGREATrandino
New Member
- Joined
- Sep 9, 2020
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
I'm trying to use xlookup in a vba macro to search a table and I can't make it work.
in the spreadsheet this formula works =XLOOKUP(E3,tbl_DateRanges[Date Range],tbl_DateRanges[To])
In VBA Private Sub Worksheet_Change(ByVal Target As Range) this does not work
Range("I3").Value = Application.WorksheetFunction.XLookup(E3, Range("tbl_DateRanges[Date Range]"), Range("tbl_DateRanges[To]")
It generates Run-Time error "1004': Method "Range" of object _Worksheet' failed
when I try
Range("I3").Value = Application.WorksheetFunction.XLookup(E3,tbl_DateRanges[Date Range], tbl_DateRanges[To])
I get Compile error: Expected; list separator or )
in the spreadsheet this formula works =XLOOKUP(E3,tbl_DateRanges[Date Range],tbl_DateRanges[To])
In VBA Private Sub Worksheet_Change(ByVal Target As Range) this does not work
Range("I3").Value = Application.WorksheetFunction.XLookup(E3, Range("tbl_DateRanges[Date Range]"), Range("tbl_DateRanges[To]")
It generates Run-Time error "1004': Method "Range" of object _Worksheet' failed
when I try
Range("I3").Value = Application.WorksheetFunction.XLookup(E3,tbl_DateRanges[Date Range], tbl_DateRanges[To])
I get Compile error: Expected; list separator or )