Firstly 90% of that code isn't needed, why not attach a sample workbook so we can see your structure, show us a before and after and we'll be able to help you!
Firstly 90% of that code isn't needed, why not attach a sample workbook so we can see your structure, show us a before and after and we'll be able to help you!
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)