YUP..... it's those friggen merged cells !!!
In the first macro, in the copy data to scrathpad portion, in the line
lr = ws.Cells(Rows.Count, 1).End(xlUp).Row
Excel was not getting the last row of column1 (A), it's getting the top of the merged area. I change the 1 to 2 in order to use column B to find the last row and now it works for one of your IT sample sheet and not the LOG sheet, complains about can't change part of a merged cell, and that's even after adding 10 to lr.
Not sure what's required but I'm looking into it.
If another member has a solution for this, PLEASE help us out. Thanks.
|