adding formula to cell
 

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

adding formula to cell
 

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" wrote in message
...
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????

adding formula to cell
 

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