+ Reply to Thread
Results 1 to 3 of 3

VBA Brain Needed!

  1. #1
    Registered User
    Join Date
    03-04-2008
    Posts
    34

    VBA Brain Needed!

    DominicB gave me this VBA code. I thought I'd be able to figure out how to adjust it for my worksheet. Apparently, I am not that bright. Can someone please help? I have two tables with ranges, B3 to I11, and B15 to I23. The first table is pulling from L3 to S11, and the second pulls from L15 to S23. How do I enter those parameters into this code? Thanks Much!

    Sub test()
    a = Selection(1).Row
    For n = a To Selection.Count + a
    For f = a To Selection.Count + a
    If Cells(n, 1).Value = Cells(f, 3).Value Then
    Cells(n, 1).Interior.ColorIndex = Cells(f, 3).Interior.ColorIndex
    End If
    Next f
    Next n
    End Sub

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Please edit your post to add code tags, and amend the title to be descriptive of the problem.

    Thanks.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    This appears to be a continuation of this post

    http://www.excelforum.com/showthread.php?t=640606

    I really suggest that you follow shg's suggestion that you read the Forum Rules about Code Tags, "bumping" and unanswered thread, & Thread Titles
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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