Run-time error '1004': Unable to get the VLookup property of the WorksheetFunction c

When I run the maco in this file (see attached), I get the error:

Run-time error '1004':
Unable to get the VLookup property of the WorksheetFunction class

The debugger points to a line of code that refers to the first tab, but that's as much as I can understand.

I have been happily running the macro for months now on a daily basis and even yesterday it worked fine. Today, this error. Nothing has changed in the raw data as far as I can tell, but something is amiss.

I have attached the report, with the macro enabled, so it can be run and the error duplicated.

Any help is appreciated.

Hi BlondOIverBlue

Just looking at the data, I notice you have a Tech 4098 in Sheet R&D Technicians but not in Sheet R&D Jobs. You have a Tech 4099 in sheet R&D Jobs but not in Sheet R&D Technicians.

I would guess this is the cause of your error.

John

Hi BlondOIverBlue

I've met plenty of extremely bright blonds in my 69 years. Doesn't fly with me.

John