I'm now getting run-time error 91 with it highlighting my variavle rng1 as not being set. The code worked previously but now on re-opening the file isn't working.
If someone could please let me know what I need to alter here in my code I'd greatly appreciate it.
Dim x As Integer
Dim y As...