Strange. When I save it as an '.xls' file, the function breaks and I get a zero error. When I save it as an '.xslx' file, it works. Does .xls not support named ranges? Using Excel for Mac 2008.

Doesn't matter, it's working now. Thanks everybody for the assist!