View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
carlo carlo is offline
external usenet poster
 
Posts: 367
Default rows().select VBA question

On Nov 28, 9:49 am, mohavv wrote:
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


it's

Rows(a & ":" & b).select

hth

Carlo