javascript - Google sheets - make a cell value static, print value in cell on edit -

really hard explain easy question :

i want b46 contain same value, if rows added or removed

i'm sure there's easy script input given value on edit i'm not sure write

thank in advance help!

here sample. each time sheet edit, script set value on b46:

function onedit(e){    var value = /* value here */ ;   var sheet = spreadsheetapp.getactivespreadsheet().getactivesheet();   sheet.getrange("b46").setvalue(value);  } 

beware: script not modify rest of sheet remove old values.

example: if add row above row 46, script put value on new b46 cell, not delete old one.