Hi all,
I have some Vlookups in a spreadsheet that I would like to allow users to enter there own values in the field while maintaining the formula.
I found a thread on this site:
http://www.ozgrid.com/forum/showthread.php?t=91310
I folowed the directions, however I get a run time error when it runs. It a states that there is a application-defined or object-defined error. The debug points me to this line of code in the ThisWookbook section:
If InStr(LCase(.Validation.ErrorMessage), functionName) = 0 Then
I don't know very much about VBA, so any help would be appreciated.
Cheers,
Dana