+ Reply to Thread
Results 1 to 1 of 1

Paste to take destination formatting

  1. #1
    Forum Contributor
    Join Date
    09-30-2008
    Location
    Eau Claire, WI
    Posts
    184

    Paste to take destination formatting

    I have a spreadsheet that I updated and changed a lot of the formatting. The people who use it want to copy their old information over (it's a lot) and it needs to take the formatting of the destination cells in the new workbook. They don't know how/don't want to use "paste special" for everything, because it would take a lot of time. Is there a way to have it automatically take the format of the destination cells on a regular Copy & Paste?
    Last edited by jman0707; 10-01-2008 at 09:59 AM.

+ 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. Having the user specify a column when running a macro
    By garncor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-25-2008, 01:15 PM
  2. Popup window after running a macro
    By cooh23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2007, 02:55 PM
  3. 'Active' Cells Issue When Running Macro
    By JamieM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2007, 05:55 AM
  4. Running Macro with Key Shortcut
    By irish1two3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2007, 02:02 PM
  5. automatically running a macro by selecting a worksheet
    By aralebd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2006, 05:43 PM

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