View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Keystroke macro results . . .

I used to have booth versions of Office too. Then, I had problems like you
describe and decided to get rid of 2003. Why do you need old technology?
2007 will do everything that 2003 does, and a whole lot more too.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rich" wrote:

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.