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

And on a readable form :-)

Sub SelectColumns()
'Leo Heuser, 20 Oct. 2006
Dim ColArray As Variant
Dim Counter As Long
Dim SelectColumns As Range

ColArray = Array(3, 5, 8, 9, 10, 12)

With Sheets("Sheet1")
Set SelectColumns = .Columns(ColArray(LBound(ColArray)))

For Counter = LBound(ColArray) + 1 To UBound(ColArray)
Set SelectColumns = _
Union(SelectColumns, .Columns(ColArray(Counter)))
Next Counter

End With

SelectColumns.Select
End Sub

Leo heuser