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?

Looks kind of like you recorded the macro while dealing with some data
associated with a chart/graph?
Can't give you a definitive answer about the +OnAction as I haven't delved
into recording macros dealing with charts/graphs in 2007 since the early days
of its release when it could take 10 minutes just to change the color on a
graph line.

But you're right, a macro recorded while just changing values in B1:B3 ends
up looking like
Range("B1").Select
ActiveCell.FormulaR1C1 = "1"
Range("B2").Select
ActiveCell.FormulaR1C1 = "2"
Range("B3").Select
ActiveCell.FormulaR1C1 = "3"
Range("B4").Select

which could easily be made more compact as:
Range("B1").FormulaR1C1 = "1"
Range("B2").FormulaR1C1 = "2"
Range("B3").FormulaR1C1 = "3"



"what which is up" wrote:

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?

Interesting tidbit shows up with a search for VarUserMemId:
http://stackoverflow.com/questions/9...6-source-files


"what which is up" wrote:

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?

Did you install xl2010?

I've read some posts that say that this can mess up the recorded syntax. That
post mentioned xl2002, but maybe it (xl2010) breaks the recording in other
versions, too.

what which is up wrote:

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?

--

Dave Peterson

Good lord! Sure makes me glad I installed 2010 in a separate virtual machine!

"Dave Peterson" wrote:

Did you install xl2010?

I've read some posts that say that this can mess up the recorded syntax. That
post mentioned xl2002, but maybe it (xl2010) breaks the recording in other
versions, too.

what which is up wrote:

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?

--

Dave Peterson
.

Or at least didn't install it on a production pc!

JLatham wrote:

Good lord! Sure makes me glad I installed 2010 in a separate virtual machine!

"Dave Peterson" wrote:

Did you install xl2010?

I've read some posts that say that this can mess up the recorded syntax. That
post mentioned xl2002, but maybe it (xl2010) breaks the recording in other
versions, too.

what which is up wrote:

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?

--

Dave Peterson
.


--

Dave Peterson