Mcro is not working

Help Studio
, ,
1

Hi ALL,

while i am trying to delete columns in .xlsm by using macro code but getting this error

image
image974×489 109 KB

excel

image
image1102×372 60.9 KB

i want to delete these unwanted columns

Thank you

2

Hello @vineelag
You can use the Clear range activity in Excel application Scope- Modern
image

If You are a classic user, Follow this to enable Modern Activities
Activity pannel> Click Filter> Select the Show modern, then search the Modern Excel activities.
image

3

@Gokul_Jayakumar, Thank you

but i am not allowed to use modern.

4

@vineelag

Please try this

Sub delete()

Activesheet.Columns("G:R").Delete

End sub

Cheers