View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DemonTraitor DemonTraitor is offline
external usenet poster
 
Posts: 3
Default Why does Sheet.Range("A1").Select not work!!!

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