Hi,

Could you please advise on how to remove the #REF and #N/A .. I am dragging
a formual, and i get those values a lot so instead of manually deleting them
is tehre a a way to make them blank cells....I tried the Find Replace Ctrl+F
but it does not read #REF....

Thanks for your help