Only if using VBA.


Gord Dibben MS Excel MVP

On Sun, 17 Feb 2008 05:08:27 -0800 (PST), Sean wrote:

Is it possible to reference a cell by its worksheet number, rather
than its sheet name?

For e.g. Sheet1 A1 as "=worksheet(1)a1

I've tried above and it doesn't work. Reason I ask is that I have
sheets that are added and change each week. But the sheet I want to
reference will always be the "2nd" sheet from left in my workbook

Thanks