ExcelBanter - View Single Post - select multiple rows using variables

Thread: select multiple rows using variables

View Single Post

#3

Report Post

Posted to microsoft.public.excel.programming

Gary''s Student Gary''s Student is offline

Gary''s Student is offline

external usenet poster

Posts: 11,058

Default

select multiple rows using variables

Sub aRowsByAnyOtherName()
alpha = 13
omega = 17
Rows(alpha & ":" & omega).Select
End Sub

--
Gary''s Student - gsnu200830

Reply With Quote

Reply With Quote