If you still have this problem, I think the solution *might* be answered
under the thread titled, "Where else to get help?". See the last post by
Reuel for the summary.
-Reuel

"solomon_monkey" wrote:

Range("whatever")


will always refer to a range in the *active sheet*, so if you write
your
code like this you're making the assumption that the active sheet is
what
you think it is. It's very easy to later modify your code in some way
which
changes the activesheet at some point, so all your subsequent
references get
screwed up.


Always better to be specific when writing code - Excel is not aware of
your
assumptions...



Hmmm, you would have to be pretty obtuse or just plain thick to not
realise that when you change code it may change the position of other
code... fortunately (on this point at least) I am not and had been
through this with a fine F8ing and even now with qualifying the ranges
it will sometimes work and sometimes not work... :-(