Stuart,

I think you need to qualify PageVarr with the worksheet name, e.g.,

ws.PageVarr

Otherwise the code is looking at the PageVarr range on the active sheet. At
least, that's what I think is going on.

hth,

Doug Glancy

"Stuart" wrote in message
...
Ooops.
try

If I'm right, then how to AVOID the ws.Activate and
Cell Selection, please?

Regards.


"chris" wrote in message
...
If I'm right, then how to Select, please?
Select What?





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004