Posting array of strings to formulaarray property

[WillT]

I have a large number of formulas that need to be entered into a spreadsheet using VBA. I can write regular formulas to a range with a variant array but when I try to do the same thing with the ForumulaArray property of the range it changes the formulas rather than simply interring the formulas into the cells are given in the array. Can this even be done? Thanks for your help

 

[Rick Rothstein]

You have not given us much to go on there. What are you assigning to the FormulaArray property? What are they being changed to after the code enters them into your cell? What did you want to be entered into the cell?

Something I've posted in the past which may help in the future when posting questions to forums like this one...
One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data). To sum up... we only know what you tell us, nothing more.

 

[WillT]

Sorry for the ambiguous post. I have since figured it out. It was a rather complex situation related to the calculations for quadratic discriminant analysis and was too complex to describe fully and since it is part of a proprietary software package I could not post the code. I was just hoping for some insight in terms of whether or not it was possible. I now know that it is. Thanks for your cooperation and I hope I have not wasted anyone's time.

 

[Rick Rothstein]

No problem... I am glad that you have a solution.