Excel delete multiple columns




How to delete multiple columns in the excel sheet
del.xlsx (9.4 KB)

i want to remove course & fee column from the attached excel sheet .
Please provide me sequence


hi @vikumars

Based on Macro we can delete multiple columns in the sheet
use the below code
Sub sbVBS_To_Delete_Multiple_Columns ()
End Sub

Mention the column name and use Excel Application and use execute macro activity and call the function name as sbVBS_To_Delete_Multiple_Columns

Ashwin S



Could you please provide me in sequence,it will be useful to understand


Hi @vikumars,

Delete column
Try Send hot key to delete the columns.
Alt+H,D, then C

Else try Macro to delete the columns.



hi @vikumars

Please find the attachment Sample_Macro_Execution.zip (2.1 KB)


Do i need delete column activity and then use this send hot key??


hi @vikumars

@arivu96 Is telling you to use Send Hot Key Activity

Ashwin S