![]() ![]() Here is the incorrect and non working formula that resulted on my sister's Mac: (again the brackets are there) I got what I am showing by using the 'display formulas' option which apparently does not show the brackets): Here is one of the correct and working formulas that resulted on the PC (note the brackets for the array formulas are missing but they are there. Cells(4, 6).FormulaArray = "=SUM((MOD(COLUMN(RC9:RC" & lastcol & ") I have extracted the problem statement into a small example routine shown below: The problem involves the use of FormulaARRAY in my code. I am building an application on my PC that will run on my sister's Mac (latest OS, Excel V14.0.2). ![]() I am experienced in Excel VBA on the PC but not on the Mac. ![]() Software :: Formula Array In Excel For Mac 2011 (Brackets Missing) Jan 21, 2011 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |