try this
Range("h2").FormulaArray = "=sum(len(A2:g2))"

--


Gary


"durex" wrote in
message ...

Actually, to do what Im looking to do using an excel formula, you need
to use an array formula..

i.e.
For Summing all characters for row 2, columns A2 through G2...
{=SUM(LEN(A2:G2))}

But, Im not looking for the excel formula... Im looking how to do this
in vbcode.

Thanks for the suggestion!


--
durex
------------------------------------------------------------------------
durex's Profile:
http://www.excelforum.com/member.php...o&userid=27857
View this thread: http://www.excelforum.com/showthread...hreadid=478407