Updating cell references...

**ChrisMattock** · 03-02-2007, 08:55 AM

Hey guys,

So I have this spreadsheet and a macro takes values from a total column to create invoices in word. But people keep on adding columns so when Cells (i, 120) used to refer to the total it now refers to something else. Is there a simple way of this updating automatically? THANKS! :-D

**Carim** · 03-02-2007, 08:58 AM

Hi,

If you were to give a name to your range, say, totinvoice, you would no longer have to worry about its location, since it would update itself automatically ...