Stock Update
 

Update works fine when there is a ticker symbol in column but several assets
(e.g., real estate, etc) don't have ticker and so update returns error
(#VALUE!) which messes up my Net Worth SUM.

Is there any way when using MSN Money Stock Update function in Excel that if
referenced cell has no ticker entry, please do nothing? Or contrarily, can I
put something in my ticker column which tells Update to skip this row, don't
run function?

Thanks.