Results 1 to 8 of 8

Thread: Highlight Sequential Cells That Sum Up To A Value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Member
    Join Date
    Aug 2011
    Posts
    54
    Rep Power
    14
    Quote Originally Posted by snb View Post
    Code:
    Sub snb()
        j = 1
        Do Until Application.Sum(Cells(2, 11).Resize(j)) >= Cells(1, 12).Value
            j = j + 1
        Loop
        Cells(2, 13).Resize(j - 1).Interior.ColorIndex = 4
    End Sub
    Hi,

    Same result am getting.

    It is not hithlighting very near to 10 L.

    Plz fidn the attached working which i have highlighted the cells(Manualy) which is very near to 10 L.

    Kindly do the needful.

    Prabhu
    Attached Files Attached Files

Similar Threads

  1. Highlight Current Row in Excel (VBA)
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 16
    Last Post: 07-31-2013, 06:46 AM
  2. Replies: 13
    Last Post: 06-10-2013, 09:05 AM
  3. Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  4. Highlight Active Cell’s Row and Column
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  5. Replies: 1
    Last Post: 03-19-2013, 03:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •