Posted to microsoft.public.excel.programming

Jim Tibbetts Jim Tibbetts is offline

external usenet poster

Posts: 74

Selecting multiple areas

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting/Copying Variable Areas	Constantly Amazed	Excel Programming	3	April 26th 07 01:00 PM
Multiple print areas	grahammal[_19_]	Excel Programming	4	February 28th 06 03:25 PM
Multiple plot areas	Katie	Charts and Charting in Excel	1	November 16th 05 10:35 PM
Multiple Print areas in same sheet?	Enzo	Excel Discussion (Misc queries)	4	August 29th 05 07:58 PM
Set Multiple Print Areas	James Hamilton	Excel Discussion (Misc queries)	1	June 22nd 05 06:03 AM

All times are GMT +1. The time now is 03:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us