Thread
:
Addressing cells on inactive sheets
View Single Post
#
3
Nick Hodge
Posts: n/a
Addressing cells on inactive sheets
John
You cannot select a cell on an inactive sheet
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS
"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
Reply With Quote