Bob, thank you for the solution. I never thought about using Union that
way.

-Chuck


Bob Phillips wrote:
Kludgy, but works

Union(Columns(3), Columns(5), Columns(8), Columns(9), Columns(10),
Columns(12)).Select


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"c mateland" wrote in message
oups.com...
Excel 2003

What is the syntax for selecting multiple noncontiguous columns using
column numbers instead of letters? Example, I only know the column
numbers I want selected are 3, 5, 8-10, and 12.

Thanks.