+ Reply to Thread
Results 1 to 9 of 9

Cannot find cell borders using vba

Hybrid View

  1. #1
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Cannot find cell borders using vba

    I range a section of the code, setting 1 borders format. And then manually check the state of the Find dialog.
    I could see that setting the top along would do so correctly, that is double line style.
    When I did both top and left and then checked the dialog I could see the top had reverted to Single line. This bug was stopping the find from working.
    Cheers
    Andy
    www.andypope.info

  2. #2
    Registered User
    Join Date
    08-24-2011
    Location
    Chesterton, IN
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Cannot find cell borders using vba

    How would I adapt that to detect the border style and then change the weight from xDouble to xContinuous for an entire worksheet?

    I'm wanting to incorporate that function into a loop I have already written that goes through an entire workbook making various formatting changes to each of the worksheets.

    My problem stems from the border style being xDouble, which is an eyesore to our admin department and unfortunately I cannot change how I receive the excel file. So I have written various macros to fix the problems that have arisen but cannot for the life of me figure out the border problem.

    If you could push me in the right direction i'd be much appreciated! As this is the first forum i've found with a partial solution available. I only need to adapt it a bit to make it work in my case.

    Thanks in advance.

    Tim

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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