Results 1 to 4 of 4

Macro to run formula based on a range of data in some rows of a column REVISITED

Threaded View

  1. #1
    Registered User
    Join Date
    05-28-2013
    Location
    Sarasota, FL
    MS-Off Ver
    Excel 2003
    Posts
    9

    Macro to run formula based on a range of data in some rows of a column REVISITED

    On 5/28. I posted a problem under the thread

    "Macro to run formula based on a range of data in some rows of a column"
    http://www.excelforum.com/excel-prog...-a-column.html

    Forum Contributor tehneXus provided a great solution. I assigned his code to a Macro called "Evaluate" (Ctrl + e) and it worked perfectly on the data set I had at the time (Rows 2 through 2048). So I marked the thread “Solved”.


    Now, I have added new data (rows 2049 to 2621) and the Macro will not process the new data. I get no error messages, and it appears to run something in the background, but no data appears in columns N, O, P, & Q as it is supposed to.

    See attached Zip file for the spread sheet as it exists now (with the macro and new data in place).

    If tehneXus sees this post, or if anyone else can help, I would appreciate it.
    Attached Files Attached Files

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