smylex
08-20-2018, 06:00 AM
Hello,
I'm new to VBA, so I record my macros and try to see how they work.
My problem is I'm trying to insert a new row and VBA recorded this:
rows("1:1").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
and when I run it I get the message "Wrong number of arguments or invalid property assignment" and "rows" gets highlighted.
I know Rows() should have capital R, but when I change it, VBA turns it back to small letters.
Could anyone help me with this?
Thank you
I'm new to VBA, so I record my macros and try to see how they work.
My problem is I'm trying to insert a new row and VBA recorded this:
rows("1:1").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
and when I run it I get the message "Wrong number of arguments or invalid property assignment" and "rows" gets highlighted.
I know Rows() should have capital R, but when I change it, VBA turns it back to small letters.
Could anyone help me with this?
Thank you