How to Delete Columns in Excel without Using Collection

[maki]

Hi All,

How can I delete a column/columns (not row) in excel without using Collection?
I tried 1) Select action then 2) Delete action in Excel VBO, but I couldn't select columns..
Please tell me if above way is okay for delete specified columns.
I think [Cell Reference] value is not properly..


Ex. If I want to delete Column C and F in excel file
1) Select Action


Thank you in advance for your kind attention and help.

 

[sahil_raina_91]

Hi All,

How can I delete a column/columns (not row) in excel without using Collection?
I tried 1) Select action then 2) Delete action in Excel VBO, but I couldn't select columns..
Please tell me if above way is okay for delete specified columns.
I think [Cell Reference] value is not properly..


Ex. If I want to delete Column C and F in excel file
1) Select Action
View attachment 5685

Thank you in advance for your kind attention and help.

If you want to delete C to F (C,D,E,F) > Use Cell Reference = "C:F"
If you want to delete C and F ONLY > Select "C:C" and Delete > Select "F:F" and Delete (Need to do this separately)

 

[maki]

If you want to delete C to F (C,D,E,F) > Use Cell Reference = "C:F"
If you want to delete C and F ONLY > Select "C:C" and Delete > Select "F:F" and Delete (Need to do this separately)

Thank you so much for your ansewer!! It worked.