Macro To Delete Some Columns

[boss1982]

hi

please i want ur help, check the attached two files.

i need a macro (pop up message) to let me select which row i want then to hide all columns which total = zero

for example to run the macro in before.xlsx file then the pop up message will let me choose which row, which is row no. 12, after i select the row, i will click a button for example to hide all columns which total is zero, (which they are D & H).

thanks

[jraj1106]

Hi

The row with "Total", will that be always at the end?

[jraj1106]

Check this code:

Please Login or Register  to view this content.

[boss1982]

hi, yes it is always at the end, i tried to copy the button code to another book but it doesn't work, teeling me that check.xlsx is not found.
how to copy it, and i see that there are two codes, one as macro 1 and one as the button.

please advise.
thanks.

[jraj1106]

Copy the button code on to the code window of the sheet where the button is present. Delete the macro 1 code.

[boss1982]

thanks a lot

[boss1982]

Jraj

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