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