My apologies Jeffrey,

Yes it does work.

For some reason the formatting or something changed in my data columns.
I found an array formula to check the output of the macro and for some reason even the array formula would not work. I found various online comments about whether the column was formatted as Text or General.
It was only after I copied the ranges from the original workbook and pasted them back that everything worked.

Thanks for your help.
Regards, Dave