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:
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.