Run time error '1004' - VBA to delete column

[Vaghela]

Hi all

I am getting the following runtime error when trying to run a specific code to delete columns, any help would be appreciated. I am not sure what is going wrong here.

ERROR

Run-time error '1004':
Delete method of Range class failed


CODE

Sub Delete_Column()


Sheets("Tracker").Range("B:J,L:L,N:T,V:V,X:X,Z:AM, AO:AS").EntireColumn.Delete


Sheets("CY").Range("B:I,K:K,M:N,P:S,U:U,W:W,Y:AK, AM:AP").EntireColumn.Delete


End Sub

 

[dmt32]

Hi,
Is the sheet protected?


Dave

 

[Vaghela]

no its not protected