Solved

How do I duplicate a worksheet using VBA in Excel?

Posted on 2008-06-19
2
1,557 Views
Last Modified: 2013-11-27
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
Comment
Question by:MaineBiotech
2 Comments
 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 50 total points
Comment Utility
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
 

Author Closing Comment

by:MaineBiotech
Comment Utility
Perfect, thank you very much!
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now