Please be more specific.
What is your formula? Whare is it located? Where do you want to add
(insert?) columns? What do you expect the result formula to be? Are you sure
you don't confuse columns and rows in your question?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BEW" wrote in message
...
I have created a indirect formula that is fixed on a given column even when
a
new column is added. However, i need to have this formula advance one row
at
a time when it is copied to the following rows.