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.


---
Regards,
Norman



"Paul Hyett" wrote in message
...
In microsoft.public.excel.misc on Sat, 6 Aug 2005 at 20:49:39, Norman
Jones wrote :
Hi Paul,

My suggestion was to use a VBA procedure to acieve your objective.

Oh, right.

Unfortunately I've never used it.

If You are not familiar with macros (aka procedures)

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