Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- pianoman ------------------------------------------------------------------------ pianoman's Profile: http://www.excelforum.com/member.php...o&userid=33712 View this thread: http://www.excelforum.com/showthread...hreadid=543655 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range
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 |
#4
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
If any cell in named range = 8 then shade named range | Excel Programming |