I know this is a basic question, but I haven't used excel vb in years
so I'm trying to get some of the dust off.

I have the following vb code to copy a footer cell (which was used to
sum the contents of the column above it) and paste it to the 6 cells
to the right.
Range("E154").Select
Selection.Copy
Range("F154:L154").Select
ActiveSheet.Paste

I just want to make this a relative formula.

After a few of these, I'll start to get the swing of things again.