Here is a way to do that...

Range("1:1,3:3,7:7").Select

Note the number-colon-number ranges.

--
Rick (MVP - Excel)


"Gary''s Student" wrote in message
...
I would like to select several rows in one shot

Rows("1:3").Select works just fine to select
rows 1 thru 3
Rows("1,3,7").Select fails to select the three
required rows
Range("A1,A3,A7").EntireRow.Select works, but looks a little clumsy
--
Gary''s Student - gsnu200820