VBA Hide Non-Contiguous Columns

I am new to VBA, so far I have been mainly recording macros and reading information on the web to develop macros.

I need to Hide non-contiguous columns using a macro. However when I do so, the last selection of columns to hide does not work properly. I need to Hide Rows A through C, I, L, and N and O with columns D,E, F, G, H, J, K M and P in view (not hidden).

The first command in the macro is to UNhide all columns where there is data, that is Columns A through V. After that the code proceeds to hide the aforementioned columns. But on the last set of columns to hide , the macro seems to still have selected Columns A through V and the final result of the macro that Columns A through I, L, N, O are hidden.

Can someone help? Like I said I suspect that the problem is that the macro starts out with selecting Columns A-V, but even when I don't do that, the correct columns do not get hidden.

I've attached the spreadsheet with macros. The suspect macro is names "OrderPull" (Click on Order Pull View button).

THANK YOU.

Try changing your code to:

Please Login or Register  to view this content.

Maniacb,

YES, THAT WORKED!!!! I really need to learn a lot, and you helped!!!

Hurray!