Hello everyone!

I wonder if someone can help with the below query:

I've got a sum total in column H (based on the response to thread 'sum varying ranges' and I need to copy and paste it into the adjacent cells. I've tried to copy the cell ranges (Range(Cells(i,8)etc)and used a recorder format for the copy and paste part but I can't get it right.


Please Login or Register  to view this content.
I need a sum total in the following columns : J:N, P:Q, S:T. It would also be great to include some formatting in this, colour is 35 and border is top and bottom only. Border around has been used so I ran the recorder again and tried to paste it in but it hasn't worked (it just formats the active cell) and can't find an alternative function to help.

Please Login or Register  to view this content.
Again, huge thanks and much respect in anticipation