Found the answer.

In VBE you go to Tools > References and check the box next to "Personal".

If you do not see "Personal", go back out and look at at your Project Explorer. If is says something like VBAProject (Personal.xls) then you need to right click on the project, go into properties and then give it a Project Name of "Personal". It will then be easily identifiable in the References list.

The function worked great after that.

Thank you Richard from MrExcel for getting me pointed in the right direction.

Jeff