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
>
>
>