INDIRECT.EXT

[Kaby]

This formula:

=INDIRECT.EXT('H:\["&D100&".xls]BUYERSREQUEST'!C44)

keeps giving me a #value error...any obvious reasons....

 

[Andy Wiggins]

The source workbook has to be open.

 

[Toppers]

Try:

=INDIRECT.EXT("'H:\["&D100&".xls]BUYERSREQUEST'!C44")

and workbook can be closed.

HTH

The source workbook has to be open.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

This formula:

=INDIRECT.EXT('H:\["&D100&".xls]BUYERSREQUEST'!C44)

keeps giving me a #value error...any obvious reasons....

 

[Andy Wiggins]

Oops ... I saw INDIRECT not INDIRECT.EXT :-(

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

Try:

=INDIRECT.EXT("'H:\["&D100&".xls]BUYERSREQUEST'!C44")

and workbook can be closed.

HTH

The source workbook has to be open.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

This formula:

=INDIRECT.EXT('H:\["&D100&".xls]BUYERSREQUEST'!C44)

keeps giving me a #value error...any obvious reasons....