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