I'm trying to make my code run faster by avoiding selecting anything. It works to a point but then I keep running into a problem when I try to access a range on a sheet that wasn't selected. I wrote a short example to understand the problem better.
Sub error1004()
Dim rng As Range
Dim...