Rows 4 to 34 represent 1 row per day in a month. In doing testing on how to hide the rows I have run into a strange situation.
My hiding code:
Dim idxRow as Double
For idxRow = 4 To 34 Step 1
Rows(idxRow & "." & idxRow).Select
Selection.EntireRow.Hidden = True
What happens is row 4 gets highlighted and goes away, rows 5 to 34 move up, at the point of highlighting row 5 the shading jumps to row 6 and row 6 goes away, rows 7 to 34 move up and all continues normally.
If I manually hide rows 4 to 34 then run the above code with a False option row 5 does not unhide.
I have deleted row 5 and copy/inserted row 8 into 5th place. Procedure still fails on row 5.
I am trying this because I will eventually be selectively hiding rows, not the whole range.
Ideas on why row 5 won't hide/unhide? I assume there is something about row 5.