LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 298
Default 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
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
Excel Macro - Keystroke eric Excel Discussion (Misc queries) 3 June 24th 09 08:59 PM
Trigger Macro with keystroke VJ Excel Programming 2 April 6th 09 05:55 PM
How do I add to Auto_Open Macro keystroke Ctrl & F1 ? Norm[_6_] Excel Programming 0 February 26th 08 11:34 PM
Macro, shortcut keystroke for Hyperion Add-In [email protected] Excel Discussion (Misc queries) 0 May 2nd 07 01:58 AM
Creating a macro to let a user use a keystroke for repeatative information Kelt Excel Programming 3 June 1st 04 06:15 PM


All times are GMT +1. The time now is 01:42 AM.

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

About Us

"It's about Microsoft Excel"