Hi


I seem to have problems to add a formula to a cell.

I generat a string like "=SUM(A1;H7;U7)" and apply it like

ActiveSheet.Cells(y + k + 1, x + 1).Value = sValue
ActiveSheet.Cells(y + k + 1, x + 1).Text = sValue
ActiveSheet.Cells(y + k + 1, x + 1).Formula = sValue

and the all give an "object error"

why????

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)


Richard


"jodleren" <(E-Mail Removed)> wrote in message
news:3290ad6a-4132-4251-9d33-(E-Mail Removed)...
> Hi
>
>
> I seem to have problems to add a formula to a cell.
>
> I generat a string like "=SUM(A1;H7;U7)" and apply it like
>
> ActiveSheet.Cells(y + k + 1, x + 1).Value = sValue
> ActiveSheet.Cells(y + k + 1, x + 1).Text = sValue
> ActiveSheet.Cells(y + k + 1, x + 1).Formula = sValue
>
> and the all give an "object error"
>
> why????
>
>
>

On Oct 8, 12:16*pm, "Richard Schollar" <richardschol...@hotmail.com>
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