Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.
Reader Interactions
Comments
jefferissays
Hi, I’m trying this macro in Excel 2011 and am getting this error:
Compile error expected =
Or if I separate sub concatenate I get a syntax error
Sub Concatenate_Column() <— arrow points here
ActiveCell.Offset(0, 1).FormulaR1C1 = _ //these two lines highlighted in red
ActiveCell.Offset(0, -1) & ” ” & ActiveCell.Offset(0, 0)
Did you try the code as given in the post without making any changes. Because It works fine as is. But if you have made changes, could you provide us with your complete code so we can try and help you out.
Hi, I’m trying this macro in Excel 2011 and am getting this error:
Compile error expected =
Or if I separate sub concatenate I get a syntax error
Sub Concatenate_Column() <— arrow points here
ActiveCell.Offset(0, 1).FormulaR1C1 = _ //these two lines highlighted in red
ActiveCell.Offset(0, -1) & ” ” & ActiveCell.Offset(0, 0)
Did you try the code as given in the post without making any changes. Because It works fine as is. But if you have made changes, could you provide us with your complete code so we can try and help you out.