LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Somecallmejosh
 
Posts: n/a
Default Macro with formulas...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill formulas down in macro hhunt Excel Discussion (Misc queries) 2 February 17th 05 09:03 PM
Macro to repeat formulas in next row katiekay Excel Discussion (Misc queries) 5 February 10th 05 08:28 PM
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 12:40 AM
Building a table with formulas rather than a macro Daniel Bonallack Excel Worksheet Functions 3 January 20th 05 08:55 PM
Macro for formulas MsAmethyst Excel Worksheet Functions 1 October 28th 04 06:32 PM


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"