There's no point using VBA if formulas will do the job. Apart from the
fact that the formulas should be simpler, using macros means that the
user must enable macros, not always the case.


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94356