View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre[_6_] Pierre[_6_] is offline
external usenet poster
 
Posts: 1
Default FormulaArray..... HELP !!!

Basicely, here is my problem : try to run this sub in a new sheet :

Sub test()
Range("D10:N10").Select
Selection.FormulaArray =
=fpfp(a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a
14,a15,a16,a17,a18,a19,a20,a21,a22)"
End Sub


As the function fpfp is not defined, it should return a #NAME.

Now, add another argument at the end of the function call : a23
The string is not very long : for sure less than 100 chars.

Then you should obtain an msgbox runtime error 1004 ("Unable to set th
FormulaArray property of the Range class")

So my simple question is : How can I do it ?????
:confused

--
Message posted from http://www.ExcelForum.com