Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I am trying to create a macro that records "ultra- repetative" keystrokes in a spreadsheet. I have to select a cell, enter the "=" sign in it, then select the cell directly above it. If I start in cell A2, then, at this point, it will read.. "=(A1" in cell A2... I need an absolute reference on the A1 cell reference in the formula contained in cell A2, so I type it in as such "=($A$1" At this point, I know that I'm going to add cell A1 to another random cell in the spreadsheet... while the macro is still recording I finish typing what I need the macro to be... =($A$1+ That's it... that's all I want. Is there something that states I cannot record a macro on an incomplete formula, or is there some type of workaround? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill formulas down in macro | Excel Discussion (Misc queries) | |||
Macro to repeat formulas in next row | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Building a table with formulas rather than a macro | Excel Worksheet Functions | |||
Macro for formulas | Excel Worksheet Functions |