• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1585
  • Last Modified:

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?
0
MaineBiotech
Asked:
MaineBiotech
1 Solution
 
Saurabh Singh TeotiaCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now