View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alan Alan is offline
external usenet poster
 
Posts: 138
Default Select noncontiguous multiple columns by column number?

It's a bit long winded but you could use

Sub SelectNonContigCols()

Range(Chr(64 + 3) & ":" & Chr(64 + 3) & "," & Chr(64 + 5) & ":" &
Chr(64 + 5) & "," _
& Chr(64 + 8) & ":" & Chr(64 + 10) & "," & Chr(64 + 12) & ":" &
Chr(64 + 12)).Select

End Sub

Alan

c mateland wrote:
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.