Runtime error '91': Object variable or with block not set

Sorry MartinLiss. My mistake. I have attached the file having offshore. Thanks for your help.

Merge with this

http://www.vbforums.com/showthread.php?t=655871