Originally Posted by p45cal Finally, do you really need to do this on each selection change? I would try putting it into the Worksheet_Change event instead. Yes that worked, thank you! And I've just figured out the difference between selection change and worksheet_change, and I agree, the latter is better!
Last edited by Bob Phillips; 05-03-2022 at 08:46 AM. Reason: Removed unnecessary quoting
Forum Rules