Get rid of the selects and activates.
worksheets("HiddenSheetName").Range("A1:A10").copy _
Destination:=Worksheets("Sheet3").Range("B9")
--
Regards,
Tom Ogilvy
"tommy_gtr" wrote
in message ...
hello,
I have a little problem....
I wrote a macro, which copy data from one sheet to another. But I want
that source sheet is hidden. But when is hidden, my macro doesn't work,
cause it can't find source sheet.
Could anyone help???
Thanks a lot....
tommy
--
tommy_gtr
------------------------------------------------------------------------
tommy_gtr's Profile:
http://www.excelforum.com/member.php...o&userid=26089
View this thread: http://www.excelforum.com/showthread...hreadid=473341