+ Reply to Thread
Results 1 to 7 of 7

Amendment to a working Macro

  1. #1
    Registered User
    Join Date
    02-25-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    79

    Amendment to a working Macro

    Hi

    I have a Marcro kindly supplied by Jeff from another post.

    http://www.excelforum.com/excel-prog...worksheet.html

    The Macro highlights products that appear on my worksheet more that 3 times. What i would like is to adjust this so that it does not highlight products that appear more than 3 times if they are grouped together in say row 2,3,4 and so on, I only want them highlighted if they appear on seperate entries more than 3 times.

    Is this possible?

    Here is the Mcro

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: Amendment to a working Macro

    double post, sorry
    Last edited by RHCPgergo; 11-21-2012 at 12:09 PM. Reason: double post

  3. #3
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: Amendment to a working Macro

    I misread your post... damn! Will look at this later, sorry.
    Last edited by RHCPgergo; 11-21-2012 at 12:11 PM. Reason: I'm an idiot

  4. #4
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: Amendment to a working Macro

    Okay... I think I can't do it...

  5. #5
    Registered User
    Join Date
    02-25-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: Amendment to a working Macro

    Can anyone help with this?

  6. #6
    Registered User
    Join Date
    02-25-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: Amendment to a working Macro

    Could someone let me know if this is possible please?

  7. #7
    Registered User
    Join Date
    02-25-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: Amendment to a working Macro

    Ok guys, thanks for having a look.

    Looks like i have finally come up with something that can't be solved.

    Thanks anyway

+ 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