You probably need to update the sheet reference in the formula, the Main!
part, to the appropriate sheet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Cobbcouk" <Cobbcouk.2bga1f_1153745410.913@excelforum-nospam.com> wrote in
message news:Cobbcouk.2bga1f_1153745410.913@excelforum-nospam.com...
>
> Hi,
> Thanks for the quick replies. The formula works correctly in the same
> worksheet but not in anothe. I have just created a new worksheet and
> it works in that one; but not in the original one I created for the
> formula to work in.
>
> I don't know bloomin Excel!!!!!
>
> Thanks for the help ill just hhave to copy the sheet info across and
> hope for the best.
>
> Regards
>
> G
>
>
> --
> Cobbcouk
> ------------------------------------------------------------------------
> Cobbcouk's Profile:
http://www.excelforum.com/member.php...o&userid=32143
> View this thread: http://www.excelforum.com/showthread...hreadid=564241
>