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.
|