View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default Range ("1:7") With Variables?

My preference is to avoid strings if possible.

Sub Demo()
Dim r1 As Long
Dim r2 As Long

r1 = 1
r2 = 7
Rows(r1).Resize(r2 - r1 + 1).Select
End Sub

--
Dana DeLouis


"J@Y" wrote in message
...
How would I express Range ("1:7") by replacing the 1 and the 7 with
integer
variables?