Excel delete multiple columns

excel

#1

Hi,

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


#2

hi @vikumars

Based on Macro we can delete multiple columns in the sheet
use the below code
Sub sbVBS_To_Delete_Multiple_Columns ()
Columns(“A:C”).EntireColumn.Delete
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

Thanks
Ashwin S


#3

@AshwinS2

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


#4

Hi @vikumars,

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

Else try Macro to delete the columns.

Regards,
Arivu


#5

hi @vikumars

Please find the attachment Sample_Macro_Execution.zip (2.1 KB)


#6

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


#7

hi @vikumars

@arivu96 Is telling you to use Send Hot Key Activity

Thanks
Ashwin S