Did you try the evaluate method. Any worksheet function can be put into
the Evaluate by leaving off the equal sigh)


=sum(A1:B5")


VBA
results = Evaluate("Sum(A1:B5"))


If you have a string in the formula you must in clude the double
quotes

=if(A1="Total",True,False)

VBA
results = Evaluate("If(A1=""Total"",True,False)")


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=164981

Microsoft Office Help