Posted to microsoft.public.excel.programming

Kiloran[_2_] Kiloran[_2_] is offline

external usenet poster

Posts: 1

Selecting multiple columns

I can select Column A with either Columns("A").Select or Columns(1).Select

I can select Columns A-C with Columns("A:C").Select. However,
Columns(1:3).Select does not work.

How can I select a range of columns using a numeric reference?

--Alan

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 different multiple columns	rcg	Excel Worksheet Functions	1	September 26th 06 05:58 PM
Selecting Multiple Columns in a Named Selection	Griffithpt	Excel Worksheet Functions	0	August 9th 06 10:54 PM
Selecting multiple columns for subtotals	CEG	Excel Discussion (Misc queries)	2	January 31st 06 06:50 PM
Selecting Columns	xnman	Excel Programming	2	November 18th 03 01:52 PM
Selecting Multiple Columns	Jay[_12_]	Excel Programming	1	October 13th 03 05:35 PM

All times are GMT +1. The time now is 06:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us