Listing Formula

[drgogo]

I hope smeone can help.

Is there an easy way or idiots guide on how to list the formula used within a worksheet/wookbook.

I have about 4/5 pages in a work book and i want to have a list of the formula used on each page all for future reference.

[dominicb]

Good morning drgogo

Is there an easy way or idiots guide on how to list the formula used within a worksheet/wookbook.

No.

But that's not to say it can't be done. Download John Walkenbachs PUP v6 utility from here :
http://j-walk.com/ss/pup/pup6/trial.htm

Once installed go to PUP v6 > Auditing Tools > Formula Report, and it will list all the formulae in your workbook. Bear in mind that this add-in isn't free, but the evaluation copy isn't disabled in any way. If you keep using it you should register.

HTH

DominicB