Macro to create two copies of worksheet, then run macro.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Macro to create two copies of worksheet, then run macro.

FAQ

Thread Tools

Display Modes

01-31-2019, 08:45 AM

BCrenshaw

Windows 7 64bit Macro to create two copies of worksheet, then run macro.

Office 2016

Novice

Join Date: Jun 2016

Posts: 3

Quote:

Originally Posted by NoSparks

Perhaps something like this using variables to refer to the worksheets.

When you make a copy of a sheet, the copy automatically becomes the active sheet.

Ah that makes sense. It worked perfectly! Thanks NoSparks!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to print a value in the duplicate and triplicate copies only	Marcia	Excel Programming	2	09-26-2018 02:11 PM
Macro for printing 2 copies each on NCR paper for many different word docs	Marq	Word VBA	9	05-22-2017 08:31 PM
Looking for Help to Create a Macro (Sort)	rsrasc	Word VBA	5	04-16-2014 03:25 AM
Macro to conditionally create or go to worksheet	Reinaldo123	Excel Programming	1	07-06-2012 07:23 AM
macro for comparing data from 3 columns and pasting into another worksheet	ashukla	Excel	1	06-24-2009 05:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:51 AM.