Hi All -
I need help with VBA code to hide rows but only on specific worksheets. I'm not sure if a "case" statement is the way to go about acheiving this,but I tried it and it would only work on the first sheet. I know I'm missing something, just can't figure out what.
The following code should be performed on all worksheets:
Columns("A:A").EntireColumn.AutoFit
Range("B10:E10,G10:I10,K10:N10,P10:S10").Select
Range("P10").Activate
Selection.ColumnWidth = 10.29
Range("F10:F10,J10:J10,O10:O10").Select
Range("O10").Activate
Selection.ColumnWidth = 1.71
Rows("47:68").Select
Selection.EntireRow.Hidden = True
Range("77:77,81:81,85:85").Select
Range("A85").Activate
Selection.RowHeight = 6
Module1.Freeze_Panes_B12
Range("A1").Select
And this code should only be performed on these worksheets: "Policy Administration", "Policy Issue", "App Processing Services", "Underwriting Decisions", "Initial Claims", "Ongoing Claims Administration", "Claims Examinations"
Range("15:15,20:20").Select
Range("A20").Activate
Selection.EntireRow.Hidden = True
Bookmarks