View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
what which is up what which is up is offline
external usenet poster
 
Posts: 1
Default vb macro format is wrong

I am using Excel 2007. I have a question. I recorded a macro which enters in
A1 the value 1
B1 the value 2
C1 the value 3

the code looks like this.
Sub Macro2()
+OnAction <= VB_VarUserMemId1VB_VarUserMemId
Range& VB_VarUserMemIdB1VB_VarUserMemId '+AxisGroup
+OnAction <= VB_VarUserMemId2VB_VarUserMemId
Range& VB_VarUserMemIdC1VB_VarUserMemId '+AxisGroup
+OnAction <= VB_VarUserMemId3VB_VarUserMemId
Range& VB_VarUserMemIdD1VB_VarUserMemId '+AxisGroup
End Sub

I thought it should be this kind of format--ish
ActiveCell.FormulaR1C1 = "1)"
Range("B1").Select
ActiveCell.FormulaR1C1 = "2"
Range("C1").Select

what the heck is +OnAction format?