Help make a macro variable

[Brad]

The following macro works - how can I make it so thate the numbers can be
variable.

Sub test3()
shtGPA9D.Rows("195:198").Insert
End Sub

I would like to have something like the following
Sub test3()
dim r as integer
r = 195
shtGPA9D.Rows(r:r+3).Insert
End Sub

 

[Brad]

Why does this work with "r" defined as long and not with integer?

Sub test3()
Dim r As Long
r = 195
shtGPA9D.Rows(r & ":" & r + 3).Insert
End Sub

 

[Rick Rothstein \(MVP - VB\)]

It works for me whether 'r' is defined as Long or Integer.

Rick

 

[Jim Thomlinson]

The initial code posted Did not have the colon in Quotes. That's the
difference...