Relative (vs. Absolute) Cell References with macros

[Claude S. Weiller]

Can somebody help me with editing this simple macro. I would like to perform
the following task on any cell in my spreadsheet.

=3+(Cell address one row up)[Enter key][Down Arrow]

You'd think this is pretty simple. But I can't get the macro to execute on
any cell other than the one in which I created the macro. Pretty useless.

Also, how do you record "Right Arrow", "Left Arrow", Down Arrow", and "Up
Arrow" into macros? Would seem to be pretty basic, but I sure can't figure it
out.

Thanks a lot.

C. S. Weiller

[Excelenator]

Sub Test()
Selection.Formula = "=3+" & ActiveCell.Offset(-1, 0).Address

End Sub