How do I use "" in my cell value

[jay567]

Hi,

How would I enter a word with quotations around it through VBA? For example, I want cell 1 to show

"anyword"

instead of

anyword

Thanks for your help.

j

[anilsolipuram]

try this

range("a2").select
ActiveCell.FormulaR1C1 = """anyword"""