Inspection Details

ExcelUdfNameIsValidCellReference


Summary
Locates public User-Defined Function procedures accidentally named after a cell reference.
Reasoning
Another good reason to avoid numeric suffixes: if the function is meant to be used as a UDF in a cell formula, the worksheet cell by the same name takes precedence and gets the reference, and the function is never invoked.
The following code example(s) would trigger this inspection:

Public Function FOO1234()
End Function

The following code example(s) would not trigger this inspection:

Public Function Foo()
End Function


Back to List