vba formula working but formulaarray not workng

[catchnanan]

Dear Sir

i have attached an excel format where in cell i3 one formula s to come automatically
but because of and n formula formula array s required
but when i run the macro error s coming
can you guys kindly help

[TMS]

Try using .Formula2 rather than .Formula

[TMS]

Or, perhaps you should be using .FormulaArray?

[catchnanan]

Thank you sir
Actually .formula array returns the following error
Unable to set the FormulaArray property
I cant reduce the size of the formula
.formulaarray code is not working sir

[catchnanan]

this following code returns error Unable to set the FormulaArray property

Cells(3, 9).FormulaArray in vba


but when i use the same like Cells(3, 9).Formula in vba it works
kindly see the excel sheet you will get my point sir

[catchnanan]

Hai can any one help me with this probem
Thanks

[Fluff13]

Why not change your formula to this

Please Login or Register  to view this content.

which doesn't need array entry. That way you should be able to use VBA to add the formula without any problem

[catchnanan]

thank you very much sir
it works nicely
except one small thing/modification
in the same excel sheet,i want our formula (at the end of our formula presently is IF(H3>1000,1000,0) )
like if h2 is w (working day) and g2 is h( holiday)
then the amount should come like if h3 is less than 1000, it should be the same amount example 500 means 500 ,250 means 250 but 1000 and above means 1000 only.if h3 is more than 1000,it should be 1000 only,can the formula be changed without using And sir

[Fluff13]

In that case just change the 0 at the end of the formula to H3