Hi Wolfgang,

I have played a bit with a simpler formula:

 Code:
	$xl.Cells(1,1).Value = 1
	$xl.Cells(2,1).Value = 1
	$xl.Cells(3,1).formula = '=SUM(A1:A2)'


works as expected (Displays the sum of A1 and A2 in A3), so I assume the '=' is correct in this place .. Not sure yet why it doesn't write anything with your formula

[edith says: haven't read your post that far, so as you already came to the same conclusion (= works in simpler formulas) my post is futile :/]

Edited by Jochen (2011-09-29 04:30 PM)
_________________________