VBA - Select Multiple Columns using Column Number

[Cosmos75]

Is there a way to select multiple columns in VBA using the column number?

I have this

Range("D:E,G:H,J:K,M:N").Select
Selection.Delete Shift:=xlToLeft

But I would prefer to be able to select those columns using column numbers. It will not always be the same columns so using column numbers would be easier for me to code.

 

[chirag050675]

Dear Sir @Peter_SSs,

Can you help for loop approach which can apply to access/process noncontiguous columns
Based on column number?

I have one doubt that .Entire column can be use
To process columns of perticular range? Or it will
Process whole column of sheet?

May be I think with the help of Array of comumn number ..but how ,?

Please help.

Regards,

Chirag Raval

 

[Peter_SSs]

Sub ColsByNumber()
  Dim LastRow As Long, i As Long
  Dim aCols As Variant
  
  aCols = Split("1 4 5 8")
  LastRow = Range("A" & Rows.Count).End(xlUp).Row
  For i = 0 To UBound(aCols)
    With Columns(CLng(aCols(i))).Resize(LastRow)
      .Font.Bold = True
    End With
  Next i
End Sub

 

[chirag050675]

Dear Sir @Peter_SSs,

Yes, Amazing, work like a charm...Really very helpful forever..

Array , split based on simple space is really acceptable & new concept. really great,

And I study Clng function on here that also very helpful.

https://www.techonthenet.com/excel/formulas/clng.php

That's also very useful to understand.

Thank you very much sir for your kind help.

Regards,

Chirag Raval