We have 2 pc's, on one the code works fine, on the other it doesn't -
where should I check.

Spreadsheet 1 has a function written in VBA to return the number of
working days, based on a date supplied. It is a public function.
Spreadsheet 2 has a link to one (does not contain any vba) where it
referances a cell in spreadsheet 1 and attempts to call the working day
function.

This works fine on one PC, but not the other. Both appear to have the
same mappings and are supposed to be based on the company standard
build.

Also, if you open spreadsheet 1 and type in the working days function
(i.e. cell A1 = workingdays(now()), it will resolve itself.

It is really bugging me.


--
anthonyenglish
------------------------------------------------------------------------
anthonyenglish's Profile: http://www.excelforum.com/member.php...o&userid=15308
View this thread: http://www.excelforum.com/showthread...hreadid=572598