Thread
:
Selecting Activecell in hidden sheet
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Selecting Activecell in hidden sheet
No you don't
--
Don Guillett
SalesAid Software
"BOBODD" wrote in message
...
Much of my code was originally written to make use of Activecell.offset
commands, so I need to be able to set the activecell address at the start
of
the sub.
"Don Guillett" wrote:
Why do you need to SELECT it when referring to it will probably do
sheets("hiddensheet").range("a2").copy
or
msgbox sheets("hiddensheet").range("a2")
or
sheets("destinationsheet").range("a2")=sheets("hid densheet").range("a2")*4
--
Don Guillett
SalesAid Software
"BOBODD" wrote in message
...
Is there anyway of setting the activecell address on a hidden sheet
without
unhiding the sheet?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett