how do i include an excel formula in a vb string?
 

Hi,

Am trying to build a Macro which will deposit an excel formala into an excel
field if certain criteria are met. However - when i include a string along
the lines of "=SUM(A1:A4)" the vb scipt will kick it out when it hits the
first parenthesis as if it isn't accepting the character type within the
string.

Any suggestions of how i get round this?

how do i include an excel formula in a vb string?
 

In VBA,

If you want to insert a worksheet function into a cell do this.

Worksheets("Sheet1").Range("B1").Formula = "=SUM(A1:A4)"



"Washballs" wrote in message
...
Hi,

Am trying to build a Macro which will deposit an excel formala into an
excel
field if certain criteria are met. However - when i include a string along
the lines of "=SUM(A1:A4)" the vb scipt will kick it out when it hits the
first parenthesis as if it isn't accepting the character type within the
string.

Any suggestions of how i get round this?

how do i include an excel formula in a vb string?
 

Hi,

This should do it

Range("B1").Formula = "=SUM(A1:A4)"

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Washballs" wrote:

Hi,

Am trying to build a Macro which will deposit an excel formala into an excel
field if certain criteria are met. However - when i include a string along
the lines of "=SUM(A1:A4)" the vb scipt will kick it out when it hits the
first parenthesis as if it isn't accepting the character type within the
string.

Any suggestions of how i get round this?