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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that uses three hidden sheets 1
copy text and logo from protected, hidden sheet 1
Hidden sheets 2
how to make macro work even a sheet is hidden. 3
Copy Two Visible Ranges (From Two Sheets) To A New Workbook (AlsoWith Two Sheets) 3
Find the last hidden sheet 4
Macro to Combine Data from Multiple Sheets with Cell References 4
Run macro from active workbook whose name keeps changing 20

Back
Top