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

Sorting work on contiguous ranges.

You can sort each area separately -- or sort A10:H##.



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

--

Dave Peterson

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

Jim,

The code to select separate areas would be:

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

BUT... you can't sort with multiple ranges selected.... Sorry.

HTH,
Bernie
MS Excel MVP


"Jim Tibbetts" wrote in message
...
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

Thanks for the reply. That would work. However, I'm finding out I can't sort
multiple selections anyway.
--
Jim T


"Gary''s Student" wrote:

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

Thanks Dave.
--
Jim T


"Dave Peterson" wrote:

Sorting work on contiguous ranges.

You can sort each area separately -- or sort A10:H##.



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

--

Dave Peterson

Thanks Bernie. I didn't know you couldn't sort noncontiguous ranges. I'll
sort the ranges separately.
--
Jim T


"Bernie Deitrick" wrote:

Jim,

The code to select separate areas would be:

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

BUT... you can't sort with multiple ranges selected.... Sorry.

HTH,
Bernie
MS Excel MVP


"Jim Tibbetts" wrote in message
...
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