+ Reply to Thread
Results 1 to 2 of 2

Copy/Paste setting in excel

  1. #1
    Registered User
    Join Date
    09-28-2018
    Location
    tucson, arizona
    MS-Off Ver
    Office 365
    Posts
    1

    Copy/Paste setting in excel

    We set up daily reports via a single master copy. We usually just copy the date/day section off of one report, and then paste and save it onto all the others. Up until recently, after pasting and saving the cells on one file, the original selection would stay "highlighted" with the dotted lines and did not need to be re-copied in order to paste on the rest of the files. Now, it keeps it selected but "un-highlights" it, removing the checkered lines around the cells everytime we save a file. Any advice on how to correct this so that it goes back to how it was before?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,901

    Re: Copy/Paste setting in excel

    Hi, welcome to the forum

    If the area is still highlighted, just copy it (CTRL C), then paste wherever you want it.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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 data from WB to WB with some xtra setting
    By ahenin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2014, 03:50 PM
  2. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  3. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Access Tables & Databases
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  4. Replies: 1
    Last Post: 01-16-2013, 05:36 AM
  5. Replies: 1
    Last Post: 04-27-2006, 04:10 AM
  6. Setting a range within a loop variable for copy/paste
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2005, 12:10 PM
  7. [SOLVED] Setting a range within a loop variable for copy/paste
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-20-2005, 06:25 PM

Tags for this Thread

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