Why this VBA doesn't work?

[excelos]

I try to do this:

Range("A1").Formula = "This is some text ",TEXT((COUNTIFS(UDE!$AC:$AC,"Low",UDE!$G:$G,"High")+COUNTIFS(UDE!$AC:$AC,"4AMLD",UDE!$G:$G,"High"))/COUNTIF(UDE!$G:$G,"High"),"00%"))"
Range("A1").Formula = "=CONCATENATE("This is some text ",TEXT((COUNTIFS(UDE!$AC:$AC,"Low",UDE!$G:$G,"High")+COUNTIFS(UDE!$AC:$AC,"4AMLD",UDE!$G:$G,"High"))/COUNTIF(UDE!$G:$G,"High"),"00%"))"


Any idea?

 

[Special-K99]

What doesn't work?
I see TWO VBA statements.
The first doesn't work? The second doesn't work? They both don't work?

How don't they work?
What error are you getting?
Are you getting an error?

So many questions because of so little information supplied.

 

[excelos]

Both statements are trying to do the same time but none works.

It says Syntax error.

I want basically to make a cell contain some text ("This is some text") followed by the return from a formula.

How can I do that?

 

[Special-K99]

In your second VBA formula you need to encompass ALL strings in double double qoutes
So...

instead of
"This is some text"
use
""This is some text""

Do the same for the other text entries so Excel can determine what is part of the "formula" and what is text

 

[Fluff]

Put the formula in a cell & check that it works.
Then start the macro recorder, select the cell with the formula, hit F2, stop the recorder & you have the code.

 

[Special-K99]

Change your first formula to

Range("A1").Formula = "=""This is some text "",TEXT((COUNTIFS(UDE!$AC:$AC,""Low"",UDE!$G:$G,""High"")+COUNTIFS(UDE!$AC:$AC,""4AMLD"",UDE!$G:$G,""High""))/COUNTIF(UDE!$G:$G,""High""),""00%""))"

Again double quotes around text.

The proper format for storing a formula in a cell via VBA is

Destination.formula = "=formula"

UPDATE: I don't know if this works, but it cures the syntax errors that you originally had in both.

 

[excelos]

I still get Syntax error.

Can you write it for me or give me an example?

 

[excelos]

I put in everything double quotes and now it puts the whole thing in A1! Like the " Range("A1").Formula = "=CONCATENATE(""This is some..........."

 

[Special-K99]

Does this work?

Range("A1").Formula = "=""This is some text ""&(COUNTIFS(UDE!$AC:$AC,""Low"",UDE!$G:$G,""High"")+COUNTIFS(UDE!$AC:$AC,""4AMLD"",UDE!$G:$G,""High""))/COUNTIF(UDE!$G:$G,""High"")"

I don't have any data so am getting a DIV/0 error.


CONCATENATE( ) parameters are separated by commas.

But if you're not using the CONCATENATE function as in your first formula then you need ampersand not comma.
Like these

="ABCDE" & "FGHIJ"

=CONCATENATE("ABCDE" , "FGHIJ")

Spaces inserted for clarity.