Getting an Inputbox value to work in a later formula

[Sweedler]

Ok, SO I have been working on this MACRO that would allow me to enter a variable number of rows into my spreadsheet from a variable point. Excel is telling me that I am mucking up in the last step with the "ROWS(..." line. I just can't really figure out why it wont work and would love some help solving this one.




Sub InsertROWS()

Dim a As Integer
Dim b As Integer
Dim c As Integer

a = Application.InputBox("how many rows do you wish to add", "ADDING ROWS", Type:=1)

b = Application.InputBox("Starting from what row", "STARTING POINT", Type:=1)

c = ((a - 1) + b)

Range("e2").Value = a
Range("e3").Value = c

Rows("a:c").Value.EntireRow.Insert

End Sub

 

[Sweedler]

You needed the spaces before/after the &:

Rows(a & ":" & c).Insert

But I'm glad you got something to work.

Of course .. Thank you

 

[Sweedler]

Of course .. Thank you

You needed the spaces before/after the &:

Rows(a & ":" & c).Insert

But I'm glad you got something to work.

But now it is complaining that I have a Syntax error in my first line?

 

[Sweedler]

But now it is complaining that I have a Syntax error in my first line?

Nope, I messed up there. It works now.

Nice to have two working formulas