View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default rows().select VBA question

How can I make this work, keep getting errors.
Sub test2()
a = 327
b = 336
Rows(a:b).Select


Just a different method without strings:

Sub Demo()
Dim a As Long, b As Long

a = 327
b = 336

Rows(a).Resize(b - a + 1).Select
End Sub

--
HTH :)
Dana DeLouis


"mohavv" wrote in message
...
How can I make this work, keep getting errors.

Sub test2()

a = 327
b = 336

Rows(a:b).Select

End Sub

I just want to select/delete severals row at once at a variable spot.

Cheers,

Harold