copy from hidden sheet
 

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

copy from hidden sheet
 

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