Hey,
I'm having problems with a work sheet.
I have a spread sheet which needs to have additional rows added always to just above the sub total row.
When I try to run this as a macro the formulas are always copied to the same row, I can't get it to adjust to always insert into the row directly above the subtotal row which reference obviously changes every time I add a new row.
any advice gratefully recieved.

Thanks,

James.