I have the following formula that i am inserting with vba (it is part of a much bigger macro)
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Range("D1:D5000").Formula = _
when it runs (it is all OK) until it gets to the inserting the formula then i get an error. cant see where I am going wrong ?