Posted to microsoft.public.excel.programming
|
|
Named Range
At least we didn't fail - again <vbg
Bob
"pianoman" wrote in
message ...
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 (InsertNameDefine...) 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"
wrote in
message ...
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
|