Hi.
Range("A:H,K:K,M:M,N:N,S:S,U:U")
Note that you may have trouble with pasting not adjacent columns.
Regards.
Daniel

Hi guys,
I am trying to create a macro that would Copy Columns A-H,K,M,N,S,U from
worksheet("DrList") to WorkSheet("DrListCal") within the same workbook. I
know how to select ajacent columns but how do we deal with non ajacent ones?

Would appreciate some help codding. Thanks