Hi FTM,

You could try

=SUBSTITUTE(SUBSTITUTE("="&"$E$4*AD$2","$E$","$E"),"AD$","$AD$")

then paste special vaule and copy formula down

VBA Noob