View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Help make a macro variable

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