Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I am getting an error with the line highlighted in red in my code below.
"Unable to get the match property of the WorsheetFunction class."
n_date is returning a value of 2020-06-17. Column A of worksheet "ws_master" contains the value 2020-06-17 at row 185
"Unable to get the match property of the WorsheetFunction class."
Rich (BB code):
Sub GUI_S_Submit1()
Stop
With ws_dsched
'nd_yr = .Range("D2")
'nd_month = Month("1" & .Range("E2"))
'nd_day = .Range("F2")
'nd_month = Month(.Range("G2"))
'nd_day = Day(.Range("G2"))
'n_date = DateSerial(nd_yr, nd_month, nd_day)
'find row reference on master schedule
drow = Application.WorksheetFunction.Match(n_date, ws_master.Columns(1), 0)
End With
End Sub
n_date is returning a value of 2020-06-17. Column A of worksheet "ws_master" contains the value 2020-06-17 at row 185