Insert excel formulas from VB array..

[reginaldm]

I have been trying to get an array full of formulas to insert into a range on excel spreadsheat; however the formulas end up showing as text and not evaluating. I have tried sever different commands and none seem to work. I currently am outputing one cell's formula at a time but this is painfully slow and i was hoping to improve speed by storing them in an array and puting out the whole array of formulas at one time. Is this possible? and if it is how can it be done. range.formula = array does not seem to work.

[TheFIDDLER]

This worked for me:

Sub usearray()
Xarray = Worksheets(1).Range("C3", "K26").Formula
Worksheets(1).Range("C103", "K126") = Xarray
End Sub

Don't forget to dim the array as a variant.
(well actually, I guess if you do forget, it will do it for you anyway... but the point was don't dim as as something other than variant for this to work.)

[TheFIDDLER]

Also your destination range must be the same size as your array.

[reginaldm]

Thank You So much the only problem with my code was that i had the array declared as strings. When I changed it it worked. Never would have thought that would affect anything.