Translating WorkSheet Formula in VBA

AndyL · #1 (**permalink**) June 10th, 2008, 05:36 AM

Hello,

I have the following formula in a cell in my spreadsheet:

Code:

=IF(B1726="", "", B1726 & " (version: " & F1726 & ")")

... which I want to automate in VBA.

I've tried:

Code:

ActiveCell.Formula = "=IF(B1726="", "", B1726 & " (version: " & F1726 & ")")

but it doesn't work.

Am not sure how to translate from one to the other.

Thank you in advance for any help ...

Andy :)

BrianWren · #2 (**permalink**) June 10th, 2008, 12:16 PM

try

Code:

ActiveCell.Formula = "=IF(B1726="""", """", B1726 & "" (version: "" & F1726 & "")"")"

Every place you want a " to appear in the string that gets installed as the formula, use "". Just one doublequote [DQ] by itself ends the interpreter reading your typing as a literal string. Two DQs in a row are interpreted as one DQ in the string you are creating.

AndyL · #3 (**permalink**) June 11th, 2008, 04:13 AM

Understood - thank you :)

Need to download code?

Navigation