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

W

Washballs

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

Dennis Tucker

In VBA,

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

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

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i write records in access from excel vb code? 4
How to include a double quotation character in a string? 2
How to translate Excel formula function name to another language? 1
How can I use the " character in a string 2
How do I send an e-mail in Outlook triggered by results in Excel? 1
VB: date format in an Excel file 2
How do I use VBA or a function to do a certain type of string work 6
How do I find a specific characters position in a string variable 3

Top