Hi Dave
Many thanks for your help - your code worked perfectly. The reason
wasn't just applying the formula to the cells I needed was that
wanted it all to run from a macro and now it does.
Shirle
--
Shirley Munr
-----------------------------------------------------------------------
Shirley Munro's Profile:
http://www.excelforum.com/member.php...info&userid=83
View this thread:
http://www.excelforum.com/showthread.php?threadid=46948