you need four quotes

one way to code a formula, is to type it out on the spreadsheet like
you normally do,

then goto your macro recorder select the cell with the formula, press
F2 and enter =stop recording, look at the formula in VBA


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=531217