+ Reply to Thread
Results 1 to 2 of 2

Copy Cell Contents without Border by defualt

Hybrid View

  1. #1
    Registered User
    Join Date
    08-09-2016
    Location
    Boston
    MS-Off Ver
    Office 365
    Posts
    37

    Copy Cell Contents without Border by defualt

    Wizards,

    I'm looking for a way to have data in a cell copy and pasted to another cell without copying the OG cell's border. I know this can be accomplished with paste special, on a per case basis, but 1) this is asking a bit much for end user and 2) we would use it a lot so all those extra clicks would get a bit overwhelming.

    Can this be done by default whether it be setting default paste to all except borders, or another way of preventing any border changes in cells? I have the sheet protected, and they cant just edit the border of cells, but copy and paste seems to override this lock of cell border formatting.

    Thanks

  2. #2
    Registered User
    Join Date
    08-09-2016
    Location
    Boston
    MS-Off Ver
    Office 365
    Posts
    37

    Re: Copy Cell Contents without Border by defualt

    I've changed some formatting around, and maybe my borders on the outside of the surrounding cells as opposed to the fields inside
    the bordered area and accomplished what I'm looking for. Copying the cells where I have input no longer captures the borders as
    they officially belong to the other cells.

    Thanks to anyone who put any thought into this.

+ 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. macro to copy cell contents then remove substring of contents in new cell - Help
    By three_jeeps in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2015, 01:19 AM
  2. Macro Problem: Copy contents of cell; search for contents in another workbook
    By jfishstik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-04-2014, 12:11 PM
  3. Copy Cell Contents, Colour and Border
    By Cremorneguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2014, 05:08 PM
  4. [SOLVED] Copy Paste Contents based on contents in designated cell
    By nickmessick1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2014, 01:23 PM
  5. Copy row contents depending on Cell A contents?
    By Mattneedshelp in forum Excel General
    Replies: 5
    Last Post: 05-07-2012, 05:18 AM
  6. [SOLVED] Border style to top of 2 cells. Not dependent on cell contents, just a button for user to push to apply ...
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2006, 02:10 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