[theseus75]

I'm running Excel 2003 and I do a lot with macros. Normally, when I got into the VBA code to clean it up, it looks something like this:

Application.ScreenUpdating = False
Sheets("ptdays").Select
Range("L5:M5").Select
Selection.AutoFill Destination:=Range("L5:N5"), Type:=xlFillDefault
Range("L5:N5").Select
Range("M5:N5").Select
Selection.Cut

But now, when I record a new macro, the code looks more like this:

Sheets&VB_VarUserMemIdCAP DataVB_VarUserMemId'+Select
Range& VB_VarUserMemIdS73VB_VarUserMemId '+Select
Sheets& VB_VarUserMemIdSCIPVB_VarUserMemId '+Select
Range& VB_VarUserMemIdC5: N5VB_VarUserMemId '+Select


I'm not coder, and I had a hard time learning to read the first type. Is this some new structure to VBA or maybe some sort of view that's been changed?
Don't know if this matters, but I did have the beta of Office 2010 installed for a little while, but I uninstalled it already.

Thanks in advance for help.

[Ziggy1]

did you install Excel 2010 at any point? It seems to mess up the recorder, even if you uninstall.

[Ziggy1]

Ok sorry, I just noticed you mentioned that you installed 2010....look here

This is really all you need to focus on ( from the link)...

office 2010 hosed the macro recorder. it hosed it for both 2003 and 2007. it
replaces these 2 files with new ones and they don't work very well with the
2 previous versions.

VBE6.DLL
VBE6EXT.OLB

once i deleted them and open 2003, it replaced them with the original
versions and the macro recorder works again.
--

[theseus75]

Awesome! Thanks Ziggy. That was exactly the issue.

For anyone else who references this post, the files he mentions are in:

C:Program Files/Common Files/Microsoft Shared/VBA/VBA6

All Office apps have to be closed when you delete them, and when you open Excel again, you'll get some errors, it will repair, and then close and open again, and it's good to go!