copy to another cell even when new row is added

[Daisyreid9]

Dear forum,
I want to copy the value of cell A18 to M4 even when a new row is added.
When I use =A18 and then add a new line the value in M4 changes to A19.

I want it always to be A18

can this be done and how, please.

Daisy
ps not sure how to add my signature yet

 

[Fluff]

Hi & welcome to MrExcel
How about
=INDEX(A:A,18)

 

[Daisyreid9]

Wonderful,
thanks Fluff
that works perfectly

 

[Fluff]

You're welcome & thanks for the feedback