Hi Demon

You can't select a cell on a sheet that is not active
Why do you want to select the cell?

You can always use this to avoid the error

Application.Goto WSStats.Range("A1"), True



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DemonTraitor" wrote in message ...
I have set all my worksheets as Worksheet objects, and I am trying to
reference a particular cell/range, but the code always bombs out with
a "Select method of Range class failed"...

the line is...

WSStats.Range("A1").Select

Why will this not work?

This works...

WSStats.Activate
Range("A1").Select

But I don't want to "Activate" the worksheet in order to reference the
said cell.

Am I missing something?

Thanks