?? Dynamically Assign Formulas at runtime.

[VoodooRage]

Hi,

I have a spreadsheet and there are basically four formulas that I would like to be able to change at runtime.

open sheet.
ask user which formula to replace?
let user input replacement formula (portion)

There are four VLookup formulas that can be anywhere in the workbook.

I only need to replace the portion of the Vlookup formula that contains the spreadsheet name in literals, for every occurance in the workbook i.e. will have to step through the workbook sheets, look for the string, and replace it.

I am a competent VBA Access developer but this is a super rush ASAP and I don't have time to bugger the VBA Excel syntax.

Thanks,