Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David Smithz" wrote in message
. uk...

"Ragdyer" wrote in message
...
One way:

If you're using something like this on Sheet1:

=Sheet2!A1

Try this:

=IF(Sheet2!A1="","",Sheet2!A1)

--
HTH,
Seems to of worked a treat. Thanks for that.

David