copy from hidden sheet

  • Thread starter Thread starter tommy_gtr
  • Start date Start date
T

tommy_gtr

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
 
Get rid of the selects and activates.

worksheets("HiddenSheetName").Range("A1:A10").copy _
Destination:=Worksheets("Sheet3").Range("B9")
 
Back
Top