Using String Variable in VBA if Formula

[manuj.chawla]

Hi There,

I am assigning a string to variable in my VBA code. I need to pull this value again in if formula. The code is looking like this.

Please Login or Register  to view this content.

This is resolving the value of existing in the formula i.e. in the cell I am getting =if(condition, Test1, "Not Defined"). The problem is that after resolving the name it is not adding " " in the formula. All I need is that when this formula get resolved it should give me =if(condition, "Test1", "Not Defined")

Thanks in advance

[vandan_tanna]

try:

Please Login or Register  to view this content.

---------- Post added at 03:10 PM ---------- Previous post was at 03:09 PM ----------

Please see forum rules http://www.excelforum.com/forum-rule...rum-rules.html. Add Code tags to your post

[Denemem]

Works fine for me thx