+ Reply to Thread
Results 1 to 11 of 11

DRAW BORDERS through macro

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,936

    DRAW BORDERS through macro

    Look at what b2 to b21

    I want macro do do that for me

    Macro , look into column G , find duplicate , draw border of duplicate at column B

    Macro will run at 5o,ooo rows

    See file attached
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,581

    Re: DRAW BORDERS through macro

    There are no "duplicates" in column G, so not quite sure what you mean.

    I would hazard a guess that you mean put borders round chunks of consecutive numbers in column G, however, if that were the case then why are rows 9:13 bordered and 14:15 bordered when the numbers from G9:G15 are consecutive?

    I think you'll get a solution quicker if you fully explain the logic behind the borders.

    BSB

  3. #3
    Valued Forum Contributor
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    2016 & 365 Sub
    Posts
    647

    Re: DRAW BORDERS through macro

    @BadlySpelledBuoy
    I saw it as anagrams although I have not done anything with it.

    I am not sure that the example given is spot on though...
    If things don't change they stay the same
    Quite often there is a picnic problem (problem in chair not in computer)
    "We were not told it was impossible, so we did it."

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,581

    Re: DRAW BORDERS through macro

    @CheeseSandwich I saw it as an anagram thing at first too and nearly just moved on.

    Agree the sample data is probably a bit shonky. Have to wait for OP to pop back up and clarify I suppose.

    BSB

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,936

    Re: DRAW BORDERS through macro

    I meant column F

    ADEINORT
    ADEINORT
    ADEINORT
    ADEINORT

    It should draw the border on

    AROINTED
    DERATION
    ORDINATE
    RATIONED

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,936

    Re: DRAW BORDERS through macro

    CheeseSandwich has understood that i guess and will pour me the solution

  7. #7
    Valued Forum Contributor
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    2016 & 365 Sub
    Posts
    647

    Re: DRAW BORDERS through macro

    Maybe something like:
    Please Login or Register  to view this content.

  8. #8
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,581

    Re: DRAW BORDERS through macro

    Quote Originally Posted by makinmomb View Post
    I meant column F

    ADEINORT
    ADEINORT
    ADEINORT
    ADEINORT

    It should draw the border on

    AROINTED
    DERATION
    ORDINATE
    RATIONED
    But based on column F, rows 13 and 14 are the same so why are they not in the same grouping??
    Attached Images Attached Images
    Last edited by BadlySpelledBuoy; 06-23-2022 at 04:38 AM.

  9. #9
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,936

    Re: DRAW BORDERS through macro

    Yes BADLY they are one set , was a typo

    CheeseSandwich the borders are processing I have left the computer on while i am doing other work
    Worth the Wait

  10. #10
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,936

    Re: DRAW BORDERS through macro

    Thank you Cheese cant add reputation as given your reputation last so when give u one against a good solution

  11. #11
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,936

    Re: DRAW BORDERS through macro

    To a surprise it did all that 55,ooo rows in less than likely 1 minute , super speed macro

+ 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 Group, Label and draw borders
    By johnmitch38 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-10-2016, 01:42 PM
  2. Macro that would draw a line using cell borders after user input
    By Tom T Hall in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2014, 11:25 AM
  3. [SOLVED] Macro that can draw borders in cells with data across multiple sheets in a workbook
    By kodos10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2013, 08:01 AM
  4. Draw automatic borders using VBA
    By joh46k in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-05-2013, 03:22 AM
  5. UDF to set borders or draw line in current cell
    By DJWim in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-26-2012, 07:42 PM
  6. Unexplainable (to now) error when trying to draw borders
    By NiceLittleRabbit in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2010, 10:24 AM
  7. Using a macro to draw borders
    By Jen5309 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2008, 02:58 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