Unhide Cells Macro

Hi All,

I am looking for a macro to unhide a set of cells within different sheets in the same workbook. Basically, I would like to see the next cell that is hidden to be unhide (if that makes sense).

I have attached the sheet. For example, on the "games" sheet, I would like to unhide column I, then hide the rest of the columns until O. Next month, I will want to unhide column J and so on, for each month.

The other sheets have a similar situation, the columns may be in different places, like I have shown in the sheet.

Thanks for all the help!

Hi,
I think you really wanted to unhide the first hidden column, based on your worksheet.
I put the code below on Ctrl+U so you could do it with a keystroke while on any worksheet.
The code is:

Please Login or Register  to view this content.

See the attached and try it to see if it is what you were looking for.

Hi, that first macro keeps giving me an error every time I open another sheet within the workbook.

The second macro I cannot get to run without a sub name.

Is there any way I can get the first macro to work on all worksheets with a keystroke.

Thanks,
Ben

Ok, I got the first macro to work. Can someone create a loop so I can run that macro across all sheets?

I tried and failed.

Also, I would like to start the unhide macro from a specific column. I can input this manually into the macro if someone can write it for the different sheets.