Fantastic! I'll remember that next time I'm using a macro. Still trying to
teach myself how to use macros at the moment, but I'm getting there. Your
advice is helping that progress a great deal. Thankyou!

Neil



"jjk" wrote:

HI Neil,

Instead of hard cell references you could try naming them.
On the menu bar goto: Insert-Name-Define
You could define a name for the error cell. Lets say 'ErrCell'.
You could then use the reference of this name in your code.
Sheet4.Range("ErrCell").Value

Regards,
Jayant