Error 2029 #NAME

[aaddegraaf]

I am a newbie and this is my first post.
I have the following simple code in VBA, but I get a #NAME error in the particular cell after I put a formula in it with the following code.
I want the following formula in this cell:

= IF(ISBLANK(F293);"";"CC")

Please Login or Register  to view this content.

Now I got a #NAME error in Cell F294.
Strange about this is that, after I go to the formula bar and go to the end of the (unchanged) formula and strike ENTER, the same code is working well afterall, without error.
Changing the .Value into .Formula brings no solution.

Maybe a simple question, but I am working on it for several days without any luck.

Thanks for helping me out.
Aad de Graaf

[romperstomper]

Try:

Please Login or Register  to view this content.

[teylyn]

What are you trying to do? Write a formula into a cell? Then don't use Range().Value but Range().Formula.

Or are you trying to calculate the value in VBA and writing the result back to the cell?

[aaddegraaf]

Try:

Please Login or Register  to view this content.

That's it.
I think it is the COMMA instead of the SEMICOLON that does the trick.
Thanks Rory.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. I have done it for you this time.)

[aaddegraaf]

That's it.
I think it is the COMMA instead of the SEMICOLON that does the trick.
Thanks Rory.

I do have a similar problem with the following code. I think I am making the same mistake again but can't solve it.
I want to place a formula in a particular cell using a string code. The string is:

IF(B5="","",CONCATENATE(B5," [",E5,"]"))

So my code is"

Please Login or Register  to view this content.

Can you help me out, Rory. Thx.

[TMS]

Strictly speaking, this is a hijack. But, to save you some time ... you haven't doubled up ALL the double quotes.

[teylyn]

Is it a hijack if the OP adds a new question to the thread?

[aaddegraaf]

Strictly speaking, this is a hijack. But, to save you some time ... you haven't doubled up ALL the double quotes.

Thx Trevor. I'm still struggling with this problem. I am trying VBA for a short period of time and I'm learning every day.
IMO all the double quotes are doubled up.
Will you please write out the working code line for me.
So:
ActiveCell.Formula =
After that the string equivalent of : IF(B5="","",CONCATENATE(B5," [",E5,"]"))

The three items that the function CONCATENATE has to merge are"

cell value: B5
string: " ["
cell value: E5
string: "]"

Hope you can help me out.

[Leith Ross]

FYI to All,

Since this the second post today I have seen about VBA error codes for formulas, I have put together a table of Excel errors and they're corresponding VBA error codes...

Please Login or Register  to view this content.

[TMS]

@teylyn: no, my bad ... I misinterpreted the statement "I do have a similar problem with the following code ..."

Try:

Please Login or Register  to view this content.

[aaddegraaf]

That's it, Trevor.
It's confusing with all the quotes in a formula.
Every day I learn a little more from that beautiful VBA.

Aad de Graaf

[TMS]

You're welcome. Thanks for the rep.