For years I’ve been saying don’t Select or Activate in your VBA code unless you really need to. But I’ve forgotten when I need to, so I want to make a list.
Conditional Formatting: When you add conditional formatting, a formula with relative references (no dollar signs) will be relative to the ActiveCell rather than [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/05/11/required-activation/
Posted
May 11 2011, 08:33 AM
by
Daily Dose of Excel