+ Reply to Thread
Results 1 to 3 of 3

Locate Item and color it

Hybrid View

  1. #1
    Forum Contributor Bob@Sun's Avatar
    Join Date
    09-03-2009
    Location
    Montuak, Usa
    MS-Off Ver
    Excel 2007
    Posts
    438

    Locate Item and color it

    Hi,

    I need help for a macro that will do the following:

    Set Month = Sheets(“Sheet1”).Range(“AI5”)
    Set Item = Sheets(“Sheet1”).Range(“AI6”)
    Set Dates = Sheets(“Sheet1”).Range(“AI7”)
    Locate the cells on the Sheet and Color them.

    So in my example the macro must find P3 and Q3 and color them

    I count on your help

    Thanks in advance!
    Attached Files Attached Files
    Last edited by Bob@Sun; 02-14-2010 at 08:45 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Locate Item and color it

    Now worries Bob, I understand your code as it is.

    Note that I have added an extra row of dates in row 19. I need the extra row so that Item 1 is always 2 rows below the month.
    Last edited by NBVC; 02-13-2010 at 11:41 PM.

  3. #3
    Forum Contributor Bob@Sun's Avatar
    Join Date
    09-03-2009
    Location
    Montuak, Usa
    MS-Off Ver
    Excel 2007
    Posts
    438

    Re: Locate Item and color it

    Hi, Mallycat

    Did you uploaded any file with the new code? I do not see any attachments.

    Can you please uploaded the file again?

    Many thanks.

+ 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