I have a macro that I use to copy Named groups of cells from one work sheet to another. See below for code. The macro is pretty simple and has always worked great. Now however it is not working so great. Before it would copy my selection to the sheet “takeoff” by finding the name reference “zz_Takeoff_Last_Line” and paste the selected items above that group of cells named “zz_Takeoff_Last_Line”. The named cells “zz_Takeoff_Last_Line” would move down below what was copied and I could do it all over again with a different group of cells. The reference within the name “zz_Takeoff_Last_Line” would change to is new cell locations. Now the reference does not seem to change. So after I paste, the “zz_Takeoff_Last_Line” is not updating the cell reference. I have attached two images hope the picture can explain it.

Any help would be greatly appreciated. If needed I can share the workbook or explain more.

Please Login or Register  to view this content.

before.png

after.jpg