Macro Stops at .Formula Code

[timbo1957]

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.

[Olly]

You need to enter double quotes twice - so it becomes:

Please Login or Register  to view this content.

[timbo1957]

Thanks OllyXLS - Perfect!