Absolute references

  • Thread starter Thread starter BWGames
  • Start date Start date
B

BWGames

Hi,

I have a formula which calculates the total sum of a range of cells.

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?

Thanks,

Ben
 
BWGames said:
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?
Click to expand...
....

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