Not able to delete columns ‘Delete method of Range class failed’

[ThrottleWorks]

Hi,

I am using ‘RawSht.Columns("AN:AO").Delete’ line to delete the columns.
Till yesterday it was working fine, from today, I am facing bug on the same line.
Can anyone please help me in this.

 

[PCosta87]

Hi,

I would say the problem is with RawSht.
If RawSht is the sheet code name, perhaps that was changed at some point?

Check the project explorer to make sure you have RawSht there:

 

[Marc L]

Hi !

Merged cells within columns ?
Check if RawSht (object variable ?) is not Nothing …
​

 

[ThrottleWorks]

Hi @PCosta87 , thanks a lot for the help. RawSht is present. Code is working with RawSt.range("A1").clear.

Have a nice day ahead.

Hi @Marc L sir, no merged cells. Object is present. Have a nice day ahead.

 

[PCosta87]

Well, that sure is strange
Can you upload the file so we can take a look?

Thanks

 

[NARAYANK991]

Hi ,

See if the situation mentioned here is the reason.

https://www.mrexcel.com/forum/excel-questions/257222-delete-method-range-class-failed.html

Narayan

 

[NARAYANK991]

Hi ,

Another reason can be that the worksheet has been protected.

Narayan

 

[Deepak]

, thanks a lot for the help. RawSht is present. Code is working with RawSt.range("A1").clear.

RawSt <>RawSht

If not the typo error then both are the different name in your statement.

 

[ThrottleWorks]

Hi @Deepak sir, typo error here. However correct in code.
Have a nice day ahead.

 

[ThrottleWorks]

Hi @NARAYANK991 sir, thanks a lot for the help. Worksheet is not protected. Have a nice day ahead.

 

[Deepak]

Pls upload the blank xl.