test for formula result
 

Hi there

When I get enter this new code - the first time it worked a treat. No
having tested it by closing all and running from scratch i get a dialo
box which says - "Update Values: Sheet 1" - i haven't actually ever see
this box before - any ideas

--
rbekka3
-----------------------------------------------------------------------
rbekka33's Profile: http://www.excelforum.com/member.php...fo&userid=1403
View this thread: http://www.excelforum.com/showthread.php?threadid=26090