select multiple rows using variables

[JLR-Mart]

I have a program where I want to select a range of rows but don't know the
row numbers as these are stored as variables e.g. startrow and endrow. How
can I select rows startrow through endrow?

rows("startrow:endrow").select doesn't work and it appears that this
method must have numbers as the input e.g. rows("28:34").select

anyone know how I might acheive this?

 

[Joel]

Set MyRows =Rows(StartRow & ":" & EndRow)
MyRows.Select

 

[Gary''s Student]

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

 

[Mike H]

Try this


startrow = 10
endrow = 12
Rows(startrow & ":" & endrow).Select

Mike

 

[Don Guillett]

Sub selectvarrows()
startrow = 12
endrow = 14
Rows(startrow & ":" & endrow).Select
End Sub

 

[Dave Peterson]

One more:

Rows(startrow).resize(endrow-startrow+1).select

 

[Don Guillett]

Now if we could just all agree on a startrow and endrow