Selecting multiple areas
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
|