Perhaps the .Select property cannot cross-over sheets;
it is restricted to only the sheet where code is running.


"John Duffus" wrote in message
news:g%s6f.259490$1i.7890@pd7tw2no...
Hi,

I 'm still using Excel 97 and have this sub in a module.

Public Sub CellsOnInactiveSheet()
With Sheets("Sheet1")
.Range(.Range("A1"), .Range("B2")).Select
End With
End Sub

If any sheet except Sheet1 is active this produces an error.
I would have thought with a fully qualified address it should work with
any sheet active.

I don't really want to activate the sheet if I can help it.
Any help appreciated, thanks,
John Duffus