I just noticed, some trim() functions were missing, causing rwn to be 0. Now
however I am getting "object does not support this property or method" for
the paste line.

"PBcorn" wrote:


Full code below

the purpose of the macro is to insert a row above certain row labels (in col
2), add a new row label for this row, then add together two particualr
existing rows and paste into the new row. (using pastespecial add operation).
Note that the row labels are repeated once in each sheet.The data looks like: