Klartigue
09-08-2011, 07:49 AM
I keep getting an error with the following expression in my macro:
Sub Name()
'
' Name Broker
'
Columns("F:F").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Range("F1").Select
ActiveCell.FormulaR1C1 = "Broker"
Range("F2").Select
End Sub
Do you know whats wrong?
Sub Name()
'
' Name Broker
'
Columns("F:F").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Range("F1").Select
ActiveCell.FormulaR1C1 = "Broker"
Range("F2").Select
End Sub
Do you know whats wrong?