VBA referencing columns

Singe Column Reference

'Select column A 
Range("A:A").Select 

'Select column A
Columns(1).Select

 

Multi Column Reference

'Select columns A and D through E, and L through M, (A, D,E,L,M) 
Range("A:A, D:E, L:M").Select 
' Select columns A through C and column 5 ( A,B,C,E )
Union(Columns("A:C"),Columns(5)).Select 

'Select columns 1 through 4 (A,B,C,D)
Range(Columns(1),Columns(4)).Select 

' Select columns A,B,D
Range("A1,B1,D1").EntireColumn.Select 

'Select columns A,B,E
Application.Union(Range("A1"), Range("B1"),Range("E1")).EntireColumn.Select  


Interested in learning new skills?