Inserting Copied Row To Always Insert Above Sub Total

J

Jamess

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

Thanks,

James
 
Top