Use a variable for a worksheet name?
 

The worksheets are in a collection called Worksheets (i think).
So access the Nth member of that collection.

"Jim Cottrell" <Jim wrote in message
...
Can I use a variable to access a specific worksheet?
My worksheets are named 'Sheet (1)','Sheet (2)' . . .
Can I constuct a formula in a cell such as "='Sheet (X)'!Price" so that if
X=3 I can return the value from 'Sheet (3)'!Price ??
Thanks!