copy the data from one hidden sheet to active sheet.

Hi Team

I have a sheet which is hidden. I want to run a macro to copy paste the data from hidden sheet to active sheet in the same workbook.
Can someone help me with the macro?

Thank you,

Regards,
Kiran

Hi Kiran
Here's an attchment .. Sheets("Data") is hidden and it will be copied and pasted as values in Sheets("Result") ..
The copy for all the sheet not a specific range as you didn't mention that

you can use this line for specific range

Please Login or Register  to view this content.