How to select a Group of Columns at once? Possible?

[Shafty]

I have 2 different Groups of columns. Is it possible to quickly select a Grouped Columns at once. Thanks for reading. Please reply.

 

[JEC]

Not knowing what you are trying to do, selecting columns in VBA is not necessary.

Sub jec()
Range("A:B, C:G, K:K").Select
End Sub

 

[Shafty]

Not knowing what you are trying to do, selecting columns in VBA is not neccessary.

Sometimes it is...

 

[JEC]

I am curious
Generally, you never need .select and .activate in a VBA routine. They make your code slow and have no adding value.

Only selecting multiple sheets can be done easily with "select".

 

[Shafty]

Currently I am Automating a Process where in which columns from Different workbooks has to be copied on the respective group of columns in the mainsheet.

 

[JEC]

You should use a with statement for that. For example

Sub jcr()
   With Sheets("test")
         .Range("A8", .Cells(Rows.Count,"J").End(xlUp)).Copy .Range("M8")
   End With
End Sub