You can use an INDIRECT function to give you the range, and as it is a
string within the function then it will not change when rows are
inserted.

Hope this helps.

Pete


On Mar 24, 3:23*pm, John Bare <John
wrote:
I have absolute references set up to access data from a different sheet in
the same workbook. *When I insert new columns in the data source sheet, the
absolute reference change to reflect the movement of the columns. *I don't
want them to do that. *How do I keep the absolute references absolute.