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?
Bookmarks