View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
retsreg retsreg is offline
external usenet poster
 
Posts: 1
Default 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