Presumably you tried

=INDIRECT("'*\\10.10.1.80\Miscellaneous\Adarsh\Cal culation\[OAR Coupon -
Timesheet
- Satheesh.xls]Timesheet'!D5")

--

HTH

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


"xcelion" wrote in
message ...

HI All,

I need to give this
'*\\10.10.1.80\Miscellaneous\Adarsh\Calculation\[OAR Coupon - Timesheet
- Satheesh.xls]Timesheet'!D5* string as argument to Indirect function .
I tired several combination of single and double quotes but iam not
able to get the correct result using formula .Can any one please help

Thanks in advance
Xcelion


--
xcelion
------------------------------------------------------------------------
xcelion's Profile:
http://www.excelforum.com/member.php...o&userid=16287
View this thread: http://www.excelforum.com/showthread...hreadid=401425