Shouldn't do, it should adjust the name as well. What is the formula that
you use for the named range?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Madiya" wrote in message
oups.com...
I have a sheet which uses named ranges wich refers to the other
workbook.
It works fine.
Problem starts when I insert or delete a column in the source sheet of
other workbook.
This gives wrong referance and data fatched is wrong. I have to adjust
named ranges to get the correct data.

Is there a way which ensures the correct column referance even if I
insert or delete any column in between??


Regards,
Madiya