"BWGames" wrote...
....
I have it set to =SUM($D$5:D7), which works fine, but my macro inserts a
new row, creating a new row 5, which means my 'absolute' reference changes
to $D$6, which is not what I want, is there a way round this?
....

Try =SUM(INDIRECT("D5"):D7) .