| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does Sheet.Range("A1").Select not work!!!
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range("Reset Sheet!F13").Select Makes VBA Code Fail | Excel Programming | |||
| Range("A1").select doesn't work! | Excel Programming | |||
| Why doesn't 'Range("A65000").Select' work? | Excel Programming | |||
| Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select | Excel Programming | |||
| This does not work: Range("A1").Select | Excel Programming | |||
Hybrid Mode
