?
Solved

How do I duplicate a worksheet using VBA in Excel?

Posted on 2008-06-19
2
Medium Priority
?
1,572 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 200 total points
ID: 21822442
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
ID: 31468790
Perfect, thank you very much!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

800 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