Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I have run into a problem which likely has a very easy solution, but I just can't seem to figure it out.
Consider these couple of lines of code from a larger module ...
crid = "44779003" - this is correct
However, when I try to get the value of cdrow, the line in red leaves me with an "Unable to get the Match property of the WorksheetFunction class" error.
The value 44779003 does truly exist in workbook ws_cd at cell A4 as a number. I'm not sure why the error.
Consider these couple of lines of code from a larger module ...
Rich (BB code):
crid = ws_master.Cells(tmrow, 1)
cdrow = Application.WorksheetFunction.Match(crid, ws_cd.Columns(1), 0)
crid = "44779003" - this is correct
However, when I try to get the value of cdrow, the line in red leaves me with an "Unable to get the Match property of the WorksheetFunction class" error.
The value 44779003 does truly exist in workbook ws_cd at cell A4 as a number. I'm not sure why the error.