Use UNION:

Set r1=range("A1:A5")
set r2=range("Z1:Z100")
set r3=UNION(r1,r2)
--
Gary''s Student - gsnu200763


"Jim Tibbetts" wrote:

Can some one please help me with this line of code. I am trying to select 2
separate areas so they can be sorted together.

Range("A10:E" & Range("TEAMCOUNT").Value + 9),"G10:H" &
Range("TEAMCOUNT").Value + 9").Select

It seems that no matter what I do I get an error message.
--
Jim T