Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keystroke macro results . . .
I have Office 2003 AND Office 2007 installed on my PC.
Now, when I record a keystroke macro to put some text into a cell and hit enter, then go to the VBA Editor, the resultant macro is not what I'm used to seeing. For instance to record putting some garbage in Cell a1, I get the following: ActiveCell FormulaR1C1 <= VB_VarUserMemIdasdfasdfVB_VarUserMemId Range& VB_VarUserMemIdA3VB_VarUserMemId '+Select When I attempt to run it, I receive a "Compile error: Invalid use of peropery". What do I need to change? Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro - Keystroke | Excel Discussion (Misc queries) | |||
Trigger Macro with keystroke | Excel Programming | |||
How do I add to Auto_Open Macro keystroke Ctrl & F1 ? | Excel Programming | |||
Macro, shortcut keystroke for Hyperion Add-In | Excel Discussion (Misc queries) | |||
Creating a macro to let a user use a keystroke for repeatative information | Excel Programming |