LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default copying an existing sheet

I have a macro that creates reports from a main sheet. I want to make the new
sheets it creates come from a template, ie a sheet i call template in the
current workbook. This will eliminate multiple copy and paste steps in the
current macro.

I recorded a macro that right clicks the sheet tab, copies and renames but
that doesn't work when run.

any thoughts?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying charts to existing Worksheet Michael Hudston Excel Programming 2 October 27th 08 04:56 PM
copying specific rows to an existing sheet, based on user paramete Carlee Excel Programming 1 April 2nd 07 12:38 PM
Question when Copying an Existing Worksheet LL Excel Worksheet Functions 0 June 13th 05 03:17 PM
Copying a worksheet from a different file into existing (VB-6/VBA/ Mike Excel Programming 3 May 16th 05 11:02 PM
copying existing function Brad Excel Worksheet Functions 0 February 22nd 05 01:34 PM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"