Refreshing My User Defined Function 1

[PWD]

Following on from my previous thread (1518249 - thanks DaveInIowa) I now have a Function applied to many cells throughout various Sheets of the Workbook - in Excel 2000. Obviously I need these to update automatically when I change the data in my 'variable' cell. I've been looking around and can't see an obvious answer. I tried

 Application.Volatile

but that did what it said on the tin and just made the whole Workbook explode. Similarly 'F9' in the Formula Bar just removes the formula and substitutes the result. I can't very well ask my user to 'Press F2 & Enter' on every cell with the Function in the formula. I even tried adding the 'Refresh All' button from the 'external data' Toolbar - just in case! Surely there's something I've overlooked? Help. Please!

Many thanks, Des.

 

[PWD]

Phew! End of saga. I put a macro on a button that runs down my destination/results column (M) and, when required, puts my Function formula in that cell. This automatically updates based on my ‘value cell’ (Q7) and then carries on down to the end of column M. It then goes on to the next WorkSheet as required. Works for me. Thanks for all the positive suggestions.

Des.