I totally understand but the date ranges are used in other macros and those
work much better with values rather than formulas. Otherwise, I wouldn't
attempt to use VBA.

"royUK" wrote:


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