shahino007 Posted August 28, 2014 Share Posted August 28, 2014 Hey I'm trying to write a formula in Excel but it appears for some reason with single quotes on the values: (The formula compares between values of two cells, in this case A4 and E4 and the result should be at cell 4,4) The code in Autoit: _ExcelWriteFormula($oExcel, "=EXACT(A4:E4)",4,4) The Formula content as it appears in Excel function bar after execution: =EXACT('A4':'E4') This leads to "#NAME?" result in the excel Does anyone know how to solve this? Thanks Link to comment Share on other sites More sharing options...
Solution shahino007 Posted August 28, 2014 Author Solution Share Posted August 28, 2014 Solved itI used _ExcelWriteCell instead of _ExcelWriteFormula Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now