A referenced workbook is absolute, it won't change when you copy the
formula.

What exactly is the problem?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alain" wrote in message
.. .
Hi to all,
is it possible to make an absolute reference to a workbook, I know it is
possible with cells but for workbook I would like to learn

TIA

Alain