Hi Rob

maybe if you can tell us what you're trying to achieve we'll be able to come
up with an alternative method - because "select" is the same thing as you
clicking on a cell - and you can't click on a cell in a sheet that isn't
selected.

Cheers
JulieD

"Rob" wrote in message
...
'I want to set thye selected cell on sheet1 without having to select the
sheet. Anyone know how?

sheet1.select
sheet1.cells.select
sheet2.select
sheet1.cells(1,1).select 'won't let me do this.

Thanks
Rob