Kieran,

I think it is just 2 quotes, the 3 comes in if it immediately follows a
starting string quote or precedes a finishing string quote (and 4 if you
want double quotes).

So it should read

Worksheets(1).Cells(23, 8).Formula _
= "=if(itemnmlnk1 ""StockOut"", """", 2)"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kieran " wrote in message
...
From memory - when you want a quote " inside of other quotes " " you use
""" (3 quotes)

so Worksheets(1).Cells(23, 8).Formula _
= "=if(itemnmlnk1 "StockOut", "", 2)"
should become
Worksheets(1).Cells(23, 8).Formula _
= "=if(itemnmlnk1 """StockOut""", """, 2)"


---
Message posted from http://www.ExcelForum.com/