In microsoft.public.excel.misc on Sun, 7 Aug 2005 at 10:14:55, Norman
Jones wrote :
Hi Paul,

I've used them occasionally, but I can't pretend to be proficient with
them.

you may wish to visit David McRitchie's 'Getting Started With Macros And
User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


If you would like the example macro adapted to perfom your desired tasks,
post back with the following information:

(1) The name of the two worksheets
(2) The address of the initial data cells
(3) The exact formula that you are feeding the value into
(4) The address of the cells which are to receive the calculated results.

Thanks, but I have figured out a way to do it now.
--
Paul Hyett, Cheltenham