I have a formula that works fine in the spreadsheet. However when my Visual Basic Application opens the file and saves it as a new file, the formula no longer works. I'm wondering if its because the formula isn't written the best way.
This looks up the max value in Column E (column of numbers that are not sorted), and returns the value in same row in column A. Works great, but after the app runs, it returns the highest value in column A instead.
=LOOKUP(MAX(E2:E82), E2:E82, A2:A82)