I am trying to link to data from the 'furthest left position' to a totals
worksheet. The formula for the cell in the totals worksheet works with
='200608'!B81
but not with
=Worksheets(1)!B39
I don't want a named worksheet, just whichever is in 'furthest left position'
The Worksheet(1)!select works in code, but any ideas on referencing the
worksheet in a formula?
judy




"Norman Jones" wrote:

Hi Joeski.

Sheets(1).Select

Should be:

Worksheets(1).Select

---
Regards,
Norman