Fantastic - Thank you very much to both posters, it works a dream!


Mark


"CLR" <CLR@discussions.microsoft.com> wrote in message
news:24A3B842-9473-4051-9841-CA12073BE588@microsoft.com...
> For within the same Workbook.........
>
> =f4+Sheet1!A1)
>
> To retrieve from another workbook...........
>
> =F4+'C:\_ChuckStuff\[book2.xls]Sheet1'!A1
>
> Adjust the path and filename accordingly.....
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
> "Mark" wrote:
>
>> Hi,
>>
>> I'm sure this is very simple, but can someone please tell me the syntax
>> to
>> access a cell from another worksheet?
>>
>> e.g. =sum(F4+sheet[1]_A1)
>>
>>
>> Also, is it possible to access a cell from another /file/ ? Id imagine
>> not
>> for security reasons, but thought I would ask whilst I am here.
>>
>>
>>
>> Many thanks for your help,
>>
>>
>> Mark
>>
>>
>>