+ Reply to Thread
Results 1 to 1 of 1

VBA Code to Sort/Add/Highlight

Hybrid View

smlaff01 VBA Code to Sort/Add/Highlight 08-21-2008, 09:26 AM
  1. #1
    Registered User
    Join Date
    08-13-2007
    Posts
    68

    Unhappy VBA Code to Sort/Add/Highlight

    Hello,

    I am wondering if it is possible to create VBA code to look at a list of numbers (these numbers represent percentages, but are not stored as percentages). Say they are in (B4:B14). I was thinking if the code could look at the greatest value in the list and then sum values in descending order until it reaches 80 (which would mean the selected values would comprise 80%). Then would it possible to highlight these selected cells in the top 80%?

    Then could I clear any cells that were not highlighted?

    Thank you for any help

    Attached is the file I am working with...
    Attached Files Attached Files

+ 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. CountA - Dynamic Range - Macro
    By elcentro3m in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-10-2007, 02:54 PM
  2. Placement of a particular line of code
    By smurray444 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2007, 11:15 AM
  3. Running code while displaying a UserForm with vbModeless
    By PilgrimTim in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-06-2007, 08:08 AM
  4. Code to delete code
    By dbarelli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2006, 08:20 PM

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