macro :Cant find project or library

[kamikizzy]

I am trying to run this macro in Excel 2007 and it stops at the Chr$ This works in excel 2010 but I need to get it to work in 2007 version

can anyone point me in the right direction?

Please Login or Register  to view this content.

Kindest regards Alex

[snb]

Please use code tags !

Please Login or Register  to view this content.

[kamikizzy]

Thanks for your input I have managed to do a workaround it my not be pretty as I am still learning I managed to get it to work like this.
This is not my code it was provided by a good member on here and this site has been of immense help and i look forward to learning more.

Please Login or Register  to view this content.

Kindest Regards Alex

[royUK]

I don't follow how you define the Range. Why haven't you used snb's code, it will be much faster