KIM Chanthan
Member
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.
To solve with different name, i try with the sheet number in stead, but it doesn't work.
Thanks for help.
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)
Code:
Worksheets(2).Copy After:=ThisWorkbook.Sheets(D)
Last edited by a moderator: