Hi experts,
I am trying to create worksheet by using the following 2 codes alternatively but they are giving me the same 'Run-time error 1004' and creating the duplicate worksheets (Purpose-Processed(1)/(2) ....) every time I run macro.
The codes are:
Code 1:
Code 2:
I am not able to figure out what is wrong with these codes. The interesting thing is this same code is working in some other excel workbook with no error.
Can anybody help me understand the reason for this error?
Appreciate your response.
Thanks
Roshan Shakya
Bookmarks