Macro Stops at .Formula Code

Hi,

This code

Please Login or Register  to view this content.

Falls over at the

Please Login or Register  to view this content.

part

If I change it to

Please Login or Register  to view this content.

it works, so it obviously has something to do with the double "". Trouble is I don't want a zero I want a blank cell.

Thanks for any help.

Thanks OllyXLS - Perfect!