Need help with VBA code. Tons of code seperated in two, second part of code doesn't work.

Originally Posted by FragaGeddon

The only thing I get confused about is when you do for the "CAST" sheet: .Rows((Rw - 4) * 19 + 1 & ":" & (Rw - 3) * 19)
I'm guessing your saying start at row 0 (Rw - 4), then hide the next 19 rows, then add 1 blank row(?), and the second part would start at row 1 and hide the next 19 rows?

If Rw = 4 then (Rw - 4) = 0. 0 *19 = 0 and 0 +1 = 1. Similarly Rw = 4 then (Rw - 3) = 1. 1 *19 = 1. 1 & ":" & 19 = 1:19. So .Rows(1:19).Hidden = blHide
If Rw = 5 then (Rw - 4) = 1. 1 *19 = 1 and 19 +1 = 20. Similarly Rw = 5 then (Rw - 3) = 2. 2 *19 = 38. 20 & ":" & 38 = 20:38. So .Rows(20:38).Hidden = blHide
etc.
Rows are never added to the workbook.