I can check whether a cell has a value of #N/A by using
WorksheetFunction.IsNa(CellAddress).

-But can I put a #N/A value into a cell?- There seems to be no
equivalent of the
NA() function that you can use directly in a worksheet. Something
like
Range(CellAddress).Value=NA() ???

Putting the string equivalent "#N/A" into the cell doesn't help,
because the spreadsheet has to function in a multilanguage environment.


--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668
View this thread: http://www.excelforum.com/showthread...hreadid=376276