Help make a macro variable

B

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
 
B

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
 
R

Rick Rothstein \(MVP - VB\)

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

Rick
 
J

Jim Thomlinson

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