Macro to delete columns except selected columns

**VKR** · 01-03-2013, 11:00 AM

Hi,

I need a macro that will delete all columns except 5 columns that I identify by Header Name.

Please help on this.

Thanks,
Vikas

**JOHN H. DAVIS** · 01-03-2013, 12:17 PM

I know there must be a better way.

Please Login or Register  to view this content.

Replace the letters with your Header names and expand the Columns range to suit

**jaslake** · 01-03-2013, 05:50 PM

Hi Vikas

See this link...the code does just as you describe...if you need help adapting let me know
http://www.vbforums.com/showthread.p...delete-columns

**VKR** · 01-07-2013, 04:45 AM

It works...Thanks to both..

**JOHN H. DAVIS** · 01-07-2013, 07:38 AM

To VKR you're welcome.

To jaslake. No problems from me. It a good policy and learning experience to see different ways to solve problems.

**jaslake** · 01-07-2013, 10:01 AM

@Vikas
You're welcome...glad I could help. Thanks for the Rep.

@JOHN H. DAVIS
There's always more than one way.

Re: Macro to delete columns except selected columns