Paul,

The syntax is

=INDIRECT(double-quote single-quote double-quote & A2 &
double-quote single-quote double-quote ! A1 )





"Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in
message
news:887D6FF3-D552-4942-A551-0F99A11730F1@microsoft.com...
> Bob,
>
> Many thanks but I can't get this to work. I have played around
> with the " '
> and ( ) but I can't seem to get the logic right. I also tried
> to insert a ,
> before A1 but that didn't seem to help either. I'm probably
> doing something
> stupid!
> Regards
> Paul
>
> "Bob Phillips" wrote:
>
>> =INDIRECT("'"&A2&"'!A1)
>>
>> where A2 holds the sheet name
>>
>> --
>> HTH
>>
>> Bob Phillips
>>
>> (remove nothere from email address if mailing direct)
>>
>> "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote
>> in message
>> news:374FB5AC-5BA2-4BE4-A999-4CC875481941@microsoft.com...
>> > I have a 'Master' worksheet containing a list of the other
>> > worksheets in
>> this
>> > workbook. The list will be added to regularly. I want to
>> > create a macro
>> that
>> > when run will take the worksheet name that is highlighted in
>> > the 'master'
>> > list and GoTo cell A1 on the related 'Detail' sheet.
>> > Any help would be much appreciated.
>>
>>
>>