Hi Chris

=INDIRECT("'"&X1&"'!A1)
where X1 holds the worksheet name

Note that the quotes are " ' " and " ' ! A1"


--
Regards

Roger Govier


"ChrisP" wrote in message
...
hi

How do I write a cell reference to another sheet, using another
cellvalue.
Example
Instead of writing ='sheet2'!A1
Id like to set the name of the "sheet" using the value of another
cell.
Seems easy enough but I cant seem to get the syntax right.
Thanks!