Macro to delete some columns

**boss1982** · 01-31-2013, 03:38 AM

Hi,

please i want to delete all columns if the value = zero in specific row

i did this code to hide the columns, can u help to delete them?

Please Login or Register  to view this content.

thanks.

**OllieB** · 01-31-2013, 03:46 AM

Try

Please Login or Register  to view this content.

**boss1982** · 01-31-2013, 04:05 AM

Sorry,

looks like not working....
thanks.

**OllieB** · 01-31-2013, 04:17 AM

Then probably the columns are not hidden yet.

Please try this code

Please Login or Register  to view this content.

**boss1982** · 02-07-2013, 12:14 AM

Ollie,

Ur macro is working very good, but if there is a lot of columns to be deleted will not work perfectly, i mean that i have to run the macro many times to delete all column

Could u plz help

Thanks

**OllieB** · 02-07-2013, 02:42 AM

That is probably because the macro is deleting the columns from left to right. This can cause a problem because the letters of the columns will change once you delete a column that is on the left. We should reverse the process (i.e. delete from right to left).

Try:

Please Login or Register  to view this content.

**boss1982** · 02-07-2013, 03:00 AM

thanks a lot OllieB,

it is working

**OllieB** · 02-07-2013, 03:08 AM

Good to hear and you are welcome. Please remember to mark your thread as SOLVED and to click on the star icon if you are happy with my contribution!

**OllieB** · 02-07-2013, 03:10 AM

PS

the code posted in #6 contains one small typing error

the last occurence of the below statement

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

I have corrected the code posted in #6

Macro to delete some columns

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete some columns

Re: Macro to delete some columns

Re: Macro to delete some columns

Re: Macro to delete some columns

Re: Macro to delete some columns

Re: Macro to delete some columns

Re: Macro to delete some columns

Re: Macro to delete some columns

Re: Macro to delete some columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions