adding formula to cell

[jodleren]

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????

 

[Richard Schollar]

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]

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