Code not working on windows97

Hi

I got this code off here and it works really well on my home pc which is using widows 2000 however i need it for work and they are using windows 97.

I get an error with the code in red
I have attached the sheets this refers to, and when i run the code it deletes the dates it matches up with in the master rota sheet which it shouldn't

Please Login or Register  to view this content.

Hope someone can help

Dave

The line is failing because the previous line is resulting in an error value being give to the outcol variable. Check the formula on the previous line.