Delete multiple columns by column name no criteria need, just delete them

**duugg** · 06-24-2009, 09:35 AM

Hello All,

I would like a macro to find the columns named "apple" and "peach" and delete them. These would always be in row 1 but would always be in different column letters which is why I want the macro to simply find these columns by their name and not by their column letter.

And yes, I do mean the entire column altogether, shifting entire columns to the left. Wipe it off the face of the earth

Thanks!

**DonkeyOte** · 06-24-2009, 09:41 AM

Perhaps along the lines of:

Please Login or Register  to view this content.

**duugg** · 06-24-2009, 10:19 AM

Worked perfectly Donkeyote, thanks!

Just so I can learn from this..I have a question...

What difference would the macro make if this line of code

Please Login or Register  to view this content.

were changed to this line of code?

Please Login or Register  to view this content.

What affect, if any would there be if the "Public" were taken out?
What advantage is there to having "Public" in there?
What dis-advantage is there to having "Public" in there, if any?

Thanks

**DonkeyOte** · 06-24-2009, 10:35 AM

If the scope is not set (neither Private nor Public) the module is by default Public so hopefully that answers all of your questions in one go... if you want to read more you could search for Scope in VBE Help files and/or Google where you will find lots of material put together by people far more knowledgeable than I.