Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative (vs. Absolute) Cell References with macros
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative (vs. Absolute) Cell References with macros
Sub Test() Selection.Formula = "=3+" & ActiveCell.Offset(-1, 0).Address End Sub -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=568020 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy an array without changing relative cell references? | Excel Worksheet Functions | |||
Relative, absolute & mixed references in many cells | Excel Worksheet Functions | |||
how to switch between relative and absolute references | New Users to Excel | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |