Inserting Copied Row To Always Insert Above Sub Total
 

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.


--
Jamess
------------------------------------------------------------------------
Jamess's Profile: http://www.excelforum.com/member.php...fo&userid=7801
View this thread: http://www.excelforum.com/showthread...hreadid=483709