Hi,

I just experimented some code linked to a slider with the values +/-1
which allowed me to deduce the actual range of values.

Cheers
Andy

michael.beckinsale wrote:
Hi Andy,

Sorry for the delay in replying.

Your solution worked fine. How did you find out what metrics to use ie
+0.05 & -0.05?

I thoroughly inspected the online help and couldn't find anything and
resorted to using the macro recorder in XL2003 to get the code l
posted.


Regards

Michael


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info