How to fix run time error '13' in Excel VBA? -

-

i have huge excel vba file (xlsm). used able run without problem. co-worker runs without problem. when run it, keeps giving me "run time error '13'". installed patch called: "excel2010-kb2956142-fullfile-x64-glb" on windows 7, 64bit machine.

here code snipet:

ipos2 = 0 on error resume next ipos2 = application.match(scomponent, sbslvlshort(), 0) on error goto 0

the debug stops @ line with: application.match else can done? know excel has no problem.

thanks help.

jennifer

enter debug mode when code "breaks".

then, in vbe "immediate" pane, enter following statement , press return key:

?typename(ipos2)

and tell me prints on next line. again in immediate pane, enter statement , press return key:

?application.match(scomponent, sbslvlshort(), 0)

then, tell me printed on next line.

whatever being stored in array causing mismatch data type associated ipos2 variable.

one other possibility have inadvertently enabled option in vbe "break on errors". in vbe check tools | options | general , ensure "break on unhandled errors" option checked. otherwise, errors wrapped in on error resume next statement raise (the application.match function return error type if value isn't found in array).

otherwise in array? have verified using locals pane examine contents? (if don't know how this, google useful!)

if not containing expect contain, need work backwards , find line of code assigns variable, , debug there. @ point, seems user error (i.e., you've provided wrong inputs procedure, in case error expected).


Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile: ...
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo...
Read more