ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007 macro recorder weirdness (https://www.excelbanter.com/excel-programming/435165-excel-2007-macro-recorder-weirdness.html)

retsreg

Excel 2007 macro recorder weirdness
 
My macro recorder doesn't seem to be working right. For example,
below is the unrecognizable output of simply selecting a cell and
typing "testing".

The recorded code doesn't work, and even shows up red in the VBA
editor. Has anyone else encountered this issue in Excel 2007?


Thanks


retsreg


Sub Macro7()
'
' Macro7 Macro
'


'
Range& VB_VarUserMemIdC2VB_VarUserMemId '+Select
ActiveCell FormulaR1C1 <= VB_VarUserMemIdtestingVB_VarUserMemId
Range& VB_VarUserMemIdC3VB_VarUserMemId '+Select
End Sub



All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com