You don't need both the ~ and the down

In A1 thru A3 I enter:

12
22
44

I select B1 and run:

Sub lop()
For Count = 1 To 3
SendKeys String:="={left}-4~"
DoEvents
Next Count
End Sub

The macro enters the following formulas in B1 thru B3:

=A1-4
=A2-4
=A3-4


Is that want you want it to do??
--
Gary''s Student - gsnu200720