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")
Now I got a #NAME error in Cell F294.Please Login or Register to view this content.
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
Bookmarks