How to copy a hidden sheet in a workbook and paste it into a new worksheet and renaming it with a value which is there in one of the cells in the source excelsheet.If there is a redudndancy in renaming then the excel should overwrite.
I am very new to vba programming and tried with a code , but that code works only for unhidden worksheets and if there is a redundancy in renaming it shows a error. I am struck. Hope i can get some help. I am currently using excel 2010
Thank you
Don't put your code3 in the ThisWorkBook module
This will copy a sheet & rename it.
Option Explicit
I'm not sure what you are doing with the rest of the code, but try this
Please Login or Register to view this content.
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks