First problem is those merged cells. You need to get rid of them if possible. Merged cells maybe are not 100% bad, but when you start using VBA code, merged cells cause extreme havoc.
Please see if you can fix the merged cells, but also, please attach a sample workbook with what you have and what you expect.
|