Find Named Range

Hi Guys,
This forum's brilliant... I haven't Not found an answer to an excel/vb problem here yet! Thanks everyone...

So, I have a named range on a sheet, and a combobox with data validation on the named list. Having the named range on a different sheet to the combobox was working fine, and the named range appeared in the name-box in all sheets, everything was fine.

I had some problems with rebel macros running code on the wrong sheets and things got corrupted, so I replaced the sheet with the combobox with a backup copy, which was working fine, and now the old sheet, on the new file won't reference the named range. The range is still present in 'name - define' etc., but you can't access the range from any other sheet now. What's gone wrong?!

I've tried deleting the combobox and starting again, but it just won't work any more.

If I have the old backup copy open in the background, the combox works fine... I assume this means it's somehow referencing the old workbook directly, but I can't find anywhere where this is defined...

Any ideas?!

Thanks,

Gareth

Sounds like the name is referring to the other workbook. Go to the Names
Dialog (Insert>Name>Define...) and select that name. If the other workbook
name is in the RefersTo value, take it out (you edit by F2 in the Refersto
box).

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"pianoman" <[email protected]> wrote in
message news:[email protected]...
>
> Hi Guys,
> This forum's brilliant... I haven't Not found an answer to an excel/vb
> problem here yet! Thanks everyone...
>
> So, I have a named range on a sheet, and a combobox with data
> validation on the named list. Having the named range on a different
> sheet to the combobox was working fine, and the named range appeared in
> the name-box in all sheets, everything was fine.
>
> I had some problems with rebel macros running code on the wrong
> sheets and things got corrupted, so I replaced the sheet with the
> combobox with a backup copy, which was working fine, and now the old
> sheet, on the new file won't reference the named range. The range is
> still present in 'name - define' etc., but you can't access the range
> from any other sheet now. What's gone wrong?!
>
> I've tried deleting the combobox and starting again, but it just
> won't work any more.
>
> If I have the old backup copy open in the background, the combox works
> fine... I assume this means it's somehow referencing the old workbook
> directly, but I can't find anywhere where this is defined...
>
> Any ideas?!
>
> Thanks,
>
> Gareth
>
>
> --
> pianoman
> ------------------------------------------------------------------------
> pianoman's Profile:
http://www.excelforum.com/member.php...o&userid=33712
> View this thread: http://www.excelforum.com/showthread...hreadid=543655
>

Thanks Bob, I think I left my brain by the bed this morning... it was exactly that... I thought I'd checked that first, as you should, but clearly not!

Thanks again,

Gareth

Originally Posted by Bob Phillips

Sounds like the name is referring to the other workbook. Go to the Names
Dialog (Insert>Name>Define...) and select that name. If the other workbook
name is in the RefersTo value, take it out (you edit by F2 in the Refersto
box).

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"pianoman" <[email protected]> wrote in
message news:[email protected]...
>
> Hi Guys,
> This forum's brilliant... I haven't Not found an answer to an excel/vb
> problem here yet! Thanks everyone...
>
> So, I have a named range on a sheet, and a combobox with data
> validation on the named list. Having the named range on a different
> sheet to the combobox was working fine, and the named range appeared in
> the name-box in all sheets, everything was fine.
>
> I had some problems with rebel macros running code on the wrong
> sheets and things got corrupted, so I replaced the sheet with the
> combobox with a backup copy, which was working fine, and now the old
> sheet, on the new file won't reference the named range. The range is
> still present in 'name - define' etc., but you can't access the range
> from any other sheet now. What's gone wrong?!
>
> I've tried deleting the combobox and starting again, but it just
> won't work any more.
>
> If I have the old backup copy open in the background, the combox works
> fine... I assume this means it's somehow referencing the old workbook
> directly, but I can't find anywhere where this is defined...
>
> Any ideas?!
>
> Thanks,
>
> Gareth
>
>
> --
> pianoman
> ------------------------------------------------------------------------
> pianoman's Profile:
http://www.excelforum.com/member.php...o&userid=33712
> View this thread: http://www.excelforum.com/showthread...hreadid=543655
>

At least we didn't fail - again <vbg>

Bob

"pianoman" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks Bob, I think I left my brain by the bed this morning... it was
> exactly that... I thought I'd checked that first, as you should, but
> clearly not!
>
> Thanks again,
>
> Gareth
>
> Bob Phillips Wrote:
> > Sounds like the name is referring to the other workbook. Go to the
> > Names
> > Dialog (Insert>Name>Define...) and select that name. If the other
> > workbook
> > name is in the RefersTo value, take it out (you edit by F2 in the
> > Refersto
> > box).
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove xxx from email address if mailing direct)
> >
> > "pianoman" <[email protected]>
> > wrote in
> > message news:[email protected]...
> > >
> > > Hi Guys,
> > > This forum's brilliant... I haven't Not found an answer to an
> > excel/vb
> > > problem here yet! Thanks everyone...
> > >
> > > So, I have a named range on a sheet, and a combobox with data
> > > validation on the named list. Having the named range on a different
> > > sheet to the combobox was working fine, and the named range appeared
> > in
> > > the name-box in all sheets, everything was fine.
> > >
> > > I had some problems with rebel macros running code on the wrong
> > > sheets and things got corrupted, so I replaced the sheet with the
> > > combobox with a backup copy, which was working fine, and now the old
> > > sheet, on the new file won't reference the named range. The range
> > is
> > > still present in 'name - define' etc., but you can't access the
> > range
> > > from any other sheet now. What's gone wrong?!
> > >
> > > I've tried deleting the combobox and starting again, but it just
> > > won't work any more.
> > >
> > > If I have the old backup copy open in the background, the combox
> > works
> > > fine... I assume this means it's somehow referencing the old
> > workbook
> > > directly, but I can't find anywhere where this is defined...
> > >
> > > Any ideas?!
> > >
> > > Thanks,
> > >
> > > Gareth
> > >
> > >
> > > --
> > > pianoman
> > >
> > ------------------------------------------------------------------------
> > > pianoman's Profile:
> > http://www.excelforum.com/member.php...o&userid=33712
> > > View this thread:
> > http://www.excelforum.com/showthread...hreadid=543655
> > >
>
>
> --
> pianoman
> ------------------------------------------------------------------------
> pianoman's Profile:
http://www.excelforum.com/member.php...o&userid=33712
> View this thread: http://www.excelforum.com/showthread...hreadid=543655
>