Inserting a column gives error msg

[ganeshm]

Dear excel ninjas,

if i try to insert a column after "G" it gives error sample sheet is posted.

I even tried changing auto filter 8 to auto filter 9 in vba, but i received error.

Is this error because of the special cells?

 

[SirJB7]

Hi, ganeshm!
I tried to do it manually and it worked fine. In your code you're not performing any column insertion... so what are you talking about?
Regards!

 

[ganeshm]

i am sorry. Actually i got some error 1004 in the beginning, but now works fine.

 

[SirJB7]

Hi, ganeshm!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!