Using variables to select rows

[PapaSmurf]

Hi,

I am trying to select a range of Rows using
Rows(variable1:variable2).Select

instead of specifying the row numbers like in
Rows("10:12").Select

this doesn't work can someone tell me how to write it so it will?

THANKS

 

[Norie]

Try this

Rows(variable1&":"&variable2).Select

By the way why are you selecting the rows?

 

[PapaSmurf]

"Rows(variable1&":"&variable2).Select " doesn't work

yes I want to move the rows elsewhere, I'm going to cut and paste them.

 

[Norie]

Works for me.

Rows(variable1 & ":" & variable2).Select

Where are you moving the rows?

Rows(variable1 & ":" & variable2).Cut

Range("A1").PasteSpecial

Rows(variable1 & ":" & variable2).Copy Range("A1").PasteSpecial

 

[PapaSmurf]

aah it works now,
I forgot the spaces.
Thanks

I need to sort the rows by numbers in column B, in ascending order, but
with numbers 16400 and 28166 first.
Is there way to do this?