+ Reply to Thread
Results 1 to 3 of 3

matching exact format as template when copy/paste issue

  1. #1
    Forum Contributor
    Join Date
    03-17-2013
    Location
    USA, IL
    MS-Off Ver
    Excel 2010
    Posts
    121

    matching exact format as template when copy/paste issue

    Hi

    Is there a way for a vba to create a copy of a tab or worksheet template and match the exact formatting (in terms of row and column spacing, cells colors, row and coi]lumn grouping and etc) as the worksheet template in the same file?
    I ran into situations whereby sometimes the copy of the template created has wider rows and columns or the groupings are regrouped when it's created. Also sometimes the columns are grouped but the rows are ungrouped though they should all be grouped. I am sure there is a way to replicate the exact formatting as the template but not quite sure how.

    Your assistance will be greatly appreciated.

    Regards,
    PI

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: matching exact format as template when copy/paste issue

    You could copy the entire worksheet instead of the cells e.g;

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    03-17-2013
    Location
    USA, IL
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: matching exact format as template when copy/paste issue

    Thank you AlphaFrog for your advice. Will do.

    Thanks again for your time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy/paste exact formulas
    By rfcomm2k in forum Excel General
    Replies: 1
    Last Post: 04-13-2017, 09:39 AM
  2. [SOLVED] VBA Code for Copy and Paste Exact Formulas in Set Ranges
    By chrisbeltran15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2015, 01:00 PM
  3. Images, keep exact format, copy to different worksheet
    By MeekeMeeke in forum Excel General
    Replies: 0
    Last Post: 07-03-2014, 10:44 AM
  4. exact copy and paste
    By jgross in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2013, 03:11 PM
  5. How to copy/paste 2 buttons in exact same place on every worksheet
    By EK1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2010, 12:17 PM
  6. Copy and paste and keep EXACT formatting
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2008, 03:58 PM
  7. exact copy/paste
    By jmwismer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1