For Next Statement: Hiding Columns on Successive Sheets not Working

I think it is actually the .Select line that is messing you up. Remove it and try

Please Login or Register  to view this content.

Sigh, double post

Thank you for replies. Unfortunately neither suggestion worked singly or together.

Can you post a sample file with your entire code included so we can see what's not happening. I'm curious as too what your Select statement is doing. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Attached is requested file. This is a work in progress. For example, formulas in Variance sheet need some work and the selection of accounts, other than the first item, in the GOTO ACCOUNTS combobox should deactive or hide the filter button. The purpose of the workbook is to make it very easy to zero in on selected accounts in selected programs (with other programs hidden) on any sheet though the CASE selections. For purposes of this demo, I have eliminated all but the first case statement for programs. Press 'SHOW ALL' to unhide all columns/rows on all sheets. Select 'Administration' in SELECT PROGRAM combobox to test the case statement referenced in this post. Thank you.

I have tried various coding between the Select Case and End Select for Case Is = "NumberOne". All throw error messages. Any ideas on correct coding?

Please Login or Register  to view this content.

That would be appreciated, xladept.

xladept, your response is exemplary! The first set of code works. Hurray! I will try the others later. The thoroughness of your response will give me a boost in understanding how to approach similar coding in the future. You get a star!! - mandora