non selected sht rng err

  1. craig.penny

    When sheet isn't selected I get an error when I try to use ranges

    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...

Some videos you may like

This Week's Hot Topics