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!