+ Reply to Thread
Results 1 to 5 of 5

Copying Data From Another Worksheet but not Copying Borders

  1. #1
    Registered User
    Join Date
    08-28-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    57

    Copying Data From Another Worksheet but not Copying Borders

    Hi

    i am wanting to run attatched macro which runs when the customer in box c11 is changed, Currently when i run it it works fine however, I am wanting to copy the Data but not the borders or the Colour fill From the items sold sheet or the items bought sheet. Please can you advise what i need to remove/add?

    Thanks for your help in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Copying Data From Another Worksheet but not Copying Borders

    Change your Test code to the code below

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-28-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    57

    Re: Copying Data From Another Worksheet but not Copying Borders

    Hi
    Thanks for this, using the above code it removes th formatting on Row 56 and the Upper border on Cell F89.
    were nearly there.

    Thanks for your help.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Copying Data From Another Worksheet but not Copying Borders

    I've added minor tweaks, it should run faster too
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-28-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    57

    Re: Copying Data From Another Worksheet but not Copying Borders

    Hi
    thanks for this, the Date, Quantity and Unit price are not displaying in the same format.and there is a underline on cell F22 which is not required.
    Thanks in advance

+ 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. [SOLVED] Copying names without borders
    By ymmotteov in forum Excel General
    Replies: 2
    Last Post: 05-11-2017, 02:32 PM
  2. Not Copying Borders of range
    By noobsesher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2015, 04:11 PM
  3. Replies: 1
    Last Post: 07-22-2014, 10:32 AM
  4. Replies: 9
    Last Post: 04-17-2013, 08:57 AM
  5. Replies: 1
    Last Post: 10-10-2012, 10:23 AM
  6. Replies: 1
    Last Post: 11-22-2011, 02:36 PM
  7. [SOLVED] How do I secure borders, make them unaffected by copying or draggi
    By sebds70 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2005, 09:06 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