Can an excel worksheet be used as UDF?

You could try Data Table It only allows you to analyse the effect of varying 2 input parameters, but you can create several data tables, and each parameter can take hundreds of different values It's little know, but efficient and available since Excel 3.0.

You could try Data Table. It only allows you to analyse the effect of varying 2 input parameters, but you can create several data tables, and each parameter can take hundreds of different values. It's little know, but efficient and available since Excel 3.0.

There is a product that I have researched but never used - search for calc4web. It takes a sheet of formulas and generates code (C++) that can be compiled into an XLL add-in. Then you can call a function that does what your sheet does.

But of course then you have an XLL to distribute, and a build step every time you change your logic, which defeats much of the point of using a spreadsheet. In my case, I wound up writing some very simple VBA code to vary my sheet "inputs" using the scenario manager, and capture my "outputs". This works if you have a batch of inputs that you can just point your macro at and step through.

EDIT: See here for a VBA-only example of doing this: using a sheet in an excel user defined function.

1 Thanks, I'll give this a shot! – Matthew Warneford May 29 '09 at 20:31 why don't you mark it up then? – I__ Oct 20 '09 at 17:17.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.