|OK, my fault. I created the ACES sheet after I pasted the formula into a cell and the formula did not recognize the new sheet name, resulting in an #REF error.|
Now that that has been taken care of the next issue appears to be with this section of the formula:
The within_text needs to be a text string, not a range. The argument could be a reference to a single cell that contains text, but unless I'm mistaken, it can't be a reference to a range, e.g. MBQR!G$1:T$3439,
The Formula Evaluate throws up a #VALUE error when it tries to evaluate the within text argument when it contains a range, but works fine with just a single cell reference.
(Please keep in mind that we can't see your workbook from where we're sitting, so we're flying kind of blind here, just trying to set up a workbook to test your formula.)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.