• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy sheet to another workbook

Status
Not open for further replies.
Hi,
Anyone can help with below issue?
I try with this code and it works fine. Just some user rename my sheet name and it cause error.
Code:
Worksheets("Product").Copy After:=ThisWorkbook.Sheets(D)
To solve with different name, i try with the sheet number in stead, but it doesn't work.
Code:
Worksheets(2).Copy After:=ThisWorkbook.Sheets(D)
Thanks for help.
 
Last edited by a moderator:
What is this? "Sheets(D)"
Where is the Sheet named ("Product") located starting from the left?
Hi Jolivanes,
Thanks for response. Along with above issue. i have just found another challenge and here is the whole script that i have just raised.
Much appreciate if you can help.
* Sheet Product is at the 2nd place from the left.

Thanks,
 
KIM Chanthan
Do not duplicate Your thread.
This thread is closed.
 
Status
Not open for further replies.
Back
Top