I get error 1004; "Unable to get the VLookup property of the
WorksheetFunction class" on the following line of code:

-myHoliday = Application.WorksheetFunction.VLookup(myDate,
Worksheets("Supporting Sheet").Range("PayPeriod"), 3)-

I'm running Excel 2002. Any suggestions?


--
ricm9
------------------------------------------------------------------------
ricm9's Profile: http://www.excelforum.com/member.php...o&userid=34613
View this thread: http://www.excelforum.com/showthread...hreadid=543865