VB Code to delete specific Columns of a specific worksheet

**akh** · 09-22-2010, 04:45 AM

Hey Guys,

I honestly tried to make use of my PHP knowledge to get this right but I haven't been able to.

What I am looking for is a macro that deletes certain columns (identified by ID # or name) in a worksheet that I specify by name.

Any ideas?

Thanks in advance!

Best,
Andy

**Marcol** · 09-22-2010, 05:39 AM

Try this

Please Login or Register  to view this content.

Where RowNo is the row that contains your header names
And
arrCols is an array with the column headers of the columns you need to delete.

Hope this helps.

**akh** · 09-22-2010, 05:45 AM

Hey Marcol,

Thanks a dozen, that is perfect... however the main problem remains that it needs to be specified to one sheet, this is where I fail, I try to put an if on top of that specifying that loop solely for If worksheet.Name = "SU11 Master File" <- that is the sheet name btw... and I break the whole thing.

I swear I wish VB were the same as PHP :-P

Can ya help me out?

Best,
Andy

**neilberl** · 09-22-2010, 07:57 AM

In the above example, define a Worksheet and then refer to it in the calls... Edited the previous poster's code, but didn't test myself....

Please Login or Register  to view this content.

**Marcol** · 09-22-2010, 08:26 AM

Try this

Please Login or Register  to view this content.

Hope this helps

[EDIT]
Sorry neilberl I was distracted while typing this post and didn't see your reply until I posted.
Well on the bright side, at least we can compare codes and akh see how to use a With Statement. Go Team ..!!!...

**akh** · 09-22-2010, 08:58 AM

You guys are amazing... I gotta finish one other task at work and I'd say in about an hour you'll what what combination of your codes did the perfect job.

Just a warning... I might need one more very minor simple piece of code after... then I'll have everything I need.

I'll be more than happy to explain what it was that I am building here then... I thought at least some knowledge of what you helped me create will give ya some satisfaction.... aside from being very cool and helpful :-)

**akh** · 09-22-2010, 09:14 AM

Alright, so 2/3 of my steps are complete... now I need to (ironically) add the step that comes before the one I have the answer to.

This is a sub that will copy the top row of a specified worksheet and put it on top of the summary worksheet (the headers), while moving all the data in the main sheet down by one (hence not overwriting anything).

You guys are my heros already.

Best,
Andy