Typo


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uL$x1I9ZGHA.4620@TK2MSFTNGP04.phx.gbl...
> Paul,
>
> Maybe you need an event macro that works upon selecting a cell with a
sheet
> name in it. I have used columns C:F for those names, you can change to
suit.
>
> 'This is worksheet event code, which means that it needs to be
> 'placed in the appropriate worksheet code module, not a standard
> 'code module. To do this, right-click on the sheet tab, select
> 'the View Code option from the menu, and paste the code in.
>
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> Const WS_RANGE As String = "C:F"
> If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
> If Target.Value <> "" Then
> Worksheets(Tragte.Value).Activate
> ActiveSheet.Range("A1").Select
> End If
> End If
> End Sub
>
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in message
> news:AEE214F6-92CB-4019-B463-30F4BF56B580@microsoft.com...
> > Bob,
> > thanks again but I obviously haven't explained my problem correctly and
> what
> > you sent me won't work. I'll try again because this is really getting to
> me
> > (and hope you still have the patience to reply!!)!!
> >
> > On Worksheet 1 - my 'Master' or 'Front-end' WS, I have a listing of the
> > companies whose details will be shown on other Worksheets within this
> > Workbook. This list has 4 columns and I want one specific one of these
to
> be
> > a link to its associated Worksheet so that when I reference this cell in
a
> > GoTo macro, it will go to cell A1 of that particular Worksheet. I'm
> assuming
> > that if the macro is created as 'relative' that it will take me to the
> sheet
> > that relates to the list entry being highlighted on the 'Master' WS.
> > The list on the Master WS will be expanded as time goes on and so this
> > automatic link to the associated detail sheet is a key part to making it
> work.
> > Once again, my thanks for any help I get.
> > Paul
> >
> > "Bob Phillips" wrote:
> >
> > > I omitted the trailing quote. You don't need to substitute the cell
> value,
> > > Excel will do that, so use
> > >
> > > =INDIRECT("'"&A2&"'!A1")
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (remove nothere from email address if mailing direct)
> > >
> > > "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in
message
> > > news:B1F5CC4F-7258-488D-9304-7048C6BA70B9@microsoft.com...
> > > > Chip,
> > > >
> > > > Thanks. I followed this exactly - I think but it still tells me I
have
> an
> > > > error. The particular worksheet I tried it on is labelled -
> Accel_Lifts -
> > > > and so I got:
> > > >
> > > > =INDIRECT("'"&Accel_Lifts&"'"!A1)
> > > >
> > > > But it comes up as a syntax error!
> > > >
> > > > Paul
> > > >
> > > > "Chip Pearson" wrote:
> > > >
> > > > > 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.
> > > > > >>
> > > > > >>
> > > > > >>
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>