Hi
I have quite a few repetitions of the scrip below with similar changing values.
IS there a neater (For each) loop that i could simplify this code rather than just repeating it?
Private Sub Worksheet_Activate()
MyRng = 4 + Sheet12.Cells(3, 5)
MyRng = "E5:" & "E" & MyRng...