Results 1 to 3 of 3

EVALUATE Method error

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    EVALUATE Method error

    Sub test()
    
    Dim i As Long
    
    i = Evaluate("=IFERROR(INDEX(A:A,1/MOD(LARGE(INDEX(($A$1:$A$20>=35)*(COUNTIF($A$1:$A$20," > "&$A$1:$A$20)*10000+COUNTIF($B$1:$B$20," > "&$B$1:$B$20)+1/ROW($A$1:$A$20)),),ROW(A1)),1)),"")")
    
    End Sub
    I think I get an error because of double quotes ... How do I fix this?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Evaluate each cell in a table column - quickest method?
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-30-2015, 05:08 PM
  2. [SOLVED] How to use COUNTIF() function within Evaluate Method
    By cgkmal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2014, 01:34 AM
  3. [SOLVED] Replace Nth Character-EVALUATE method
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2012, 01:54 PM
  4. A More Efficient Method Than the Evaluate Method?
    By anthony.mcgovern in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-22-2011, 05:39 AM
  5. Change Evaluate Method to work in windows 97
    By Dave69rock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2008, 12:16 AM
  6. Strange (?) Evaluate Method Behavior
    By Johnny Meredith in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-03-2006, 10:30 AM
  7. Evaluate method - UDFs and Formulas
    By mo_in_france in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2005, 05:06 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