vba - Weird Excel bug when deleting sheet with named ranges? -


i have excel workbook includes 2 worskheets, wkshta , wkshtb. both have local named ranges (the scope of each named range parent sheet). cells in wksht b reference named ranges in a, none of cells in reference named ranges in b.

i have macro creates copy of each sheet within same workbook. works fine.

the problem when delete worksheet a, name manager has bunch of #ref errors names on worksheet a, scope of each has been changed "workbook." however, happens if delete worksheet before delete worksheet b. if delete them in reverse order, named ranges in deleted sheet.

another weird thing if delete a, delete #ref errors, delete b, run macro makes new copies, delete again, #ref errors don't reappear.

i'm stumped... ideas? thanks.

turns out problem way defining references b a. instance, had range in , range in b both named "premium". had snippet of code said

worksheets("b").range("premium").formula = "='a'!premium"

this worked fine, when deleted worksheet a, named range didn't delete. changing formula definition to

worksheets("b").range("premium").formula = "='a'!" & worksheets("a").range("premium").address

did trick


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more