Relative (vs. Absolute) Cell References with macros

  • Thread starter Claude S. Weiller
  • Start date
C

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
 
E

Excelenator

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

End Su
 
Top