I am trying to remove few columns with VBA

[A9kurs]

Hi Friends,

I am trying to remove the column based on their name with the help of below code but its giving error after deleting one column. Thanks for help.

Please Login or Register  to view this content.

[JBeaucaire]

A couple of rules of thumb I follow:

1. Only create variables for things that are going to be used multiple times throughout a lengthy macro. If it's one use, just reference it.
2. Try not to make big physical changes to a workbook over and over. Try to make all the changes all at once, when possible.

With that in mind, this is my approach. Find all the cells, memorize them, then delete all the found columns all at once, one time.

Please Login or Register  to view this content.

[PCI]

its giving error after deleting one column.

What is the error message?

[Fluff13]

How about

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.