Linking a defined named range to Word

V

vsoler

My Excel and Word documents are linked. Whenever I change a cell in
Excel (for example E4), its new value appears updated in my Word
document.

However, if I insert a row before row 4, the cell that is linked is
still E4 and not E5. I want that E5 be the new cell linked.

I'm thinking of using defined names instead of cells, the same way
that I use when programming a function in VBA. But I have not still
figured out how to do it.

Can anybodu help?

Your help is highly appreciated.
 
Top