Cyrus has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA
Hi, could anyone help me with VBA code for hiding columns in a workbook with 10 various worksheet?
For example, sheet 1, hide column G:G, K:K, & M:M
Sheet 2 hide column B:B, F:F, H:H
and the columns varies per each worksheet.
The purpose is to have a printable with with the remaining data.
Thanks
Cy
RE: Excel VBA
Hi Cyrus, thanks for your query. It's going to look a lot like this:
Range("G:G,K:K,M:M").Select
Selection.EntireColumn.Hidden = True
...for each sheet you need.
Hope this helps,
Anthony