On Oct 8, 12:16*pm, "Richard Schollar"
wrote:
Hi

You should use the Formula property, not Value (and certainly not Text,
which is read only).

Try removing the semi-colons from the string and replacing with commas (even
though I presume your excel version uses ; in formulas). *So sValue becomes:

sValue = SUM(A1,H7,U7)

Thanks, that's helped