Dan Wagner

2,693
reputation
2
13
18

"Ask me what 9 times f is. It's fleventy-five!" -Erlich Bachman


Handy references:

Here's an amazing post outlining how to avoid using .Select and .Activate, frequent sources of run-time errors: How to avoid using Select in Excel VBA macros

If an answer suits you, please accept it at your convenience. Here's a super-quick explanation in the form of a screenshot: http://i.stack.imgur.com/uqJeW.png