Delete all columns if value in row 2 of that column is x?

Hi Guys,

I'm looking for the correct way of deleting coulmns based on if row 2 has an x in it..

I have two versions that I tried but im pretty sure there are faster ways of doing it, I don't quite know how to delete all the columns at once.

Please Login or Register  to view this content.

The first version doesn't work for some reason and the second column works but is a slow loop, any ideas what to do to make this faster?

Try this:

Please Login or Register  to view this content.

Try this..

Please Login or Register  to view this content.

Don't forget to click *

I just made these two trying to use the union function but neither work

Please Login or Register  to view this content.

Please Login or Register  to view this content.

However neither work correctly

Originally Posted by mehmetcik

Try this...

snip

I modified yours a bit and I dont quite know how to get it working for the specific worksheet that it's on...

Please Login or Register  to view this content.

It seems to do what I want it to do but I surely should be able to do this without having to use Worksheet.Activate?

what about mine..?

Vikas Gautam

Originally Posted by Vikas_Gautam

Try this..

Please Login or Register  to view this content.

Don't forget to click *

Originally Posted by Vikas_Gautam

what about mine..?

Vikas Gautam

Your code doesn't work, the loop is wrong the way I fixed your loop is by doing:

Please Login or Register  to view this content.

However even then it still doesn't work because it has a problem I avoided in my first post by stepping backwards from far right to the left... basically if you had B2 and C2 with an x in each cell then when it deletes column B it will make C shift leftwards and then when it cycles it skips and misses C

try

Please Login or Register  to view this content.

Try this..then..

Please Login or Register  to view this content.

Don't forget to click *

or try this..

Please Login or Register  to view this content.

I have used Clearcontents method..

Don't forget to click *

Thanks for the suggetion..

Vikas Gautam