How do I duplicate a worksheet using VBA in Excel?

I'm using Microsoft Excel 2000 and VBA 6.0 and I have a project that requires me to make a macro that can duplicate a worksheet and put the duplicate next to the original (according to the tabs at the bottom). How would I go about making this happen?
MaineBiotechAsked:
Who is Participating?
 
Saurabh Singh TeotiaConnect With a Mentor Commented:
Lets say you want to copy sheet1 after that only..you can do something like this....

Sheets("Sheet1").Select
Sheets("Sheet1").Copy After:=ActiveSheet
0
 
MaineBiotechAuthor Commented:
Perfect, thank you very much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.