Excel VBA to copy -

-

my task create searchable database within excel entry form. need macro take data entry form move database sheet offset active cell down 1 row , copy values only(not formatting)

every time try run macro run-time error in code. have no experience vb or vba; please tell me wrong this. 

sheets("database").select       'navigates database worksheet if activesheet.filtermode     activesheet.showalldata end if                          'clears filters sheets("entry form").select     'navigates entry form worksheet  range("e10:l10").select           ' select date, period, , data selection.copy sheets("datatable").select      ' navigate datatable tab range("a1").select selection.end(xldown).select    ' ctrl-down last occupied row, activecell.offset(1, 0).select  ' 1 more first blank row  selection.pastespecial paste:=xlpastevalues 'pastes data values database worksheet  sheets("entry form").select     'navigates entry form worksheet application.cutcopymode = false 'clears copy data clipboard range("e10, l10").select selection.clearcontents         'clears data drop down selections  range("e10").select             'returns selection date entry box

it goes bottom of next page , gives 1004 error.

you need more column label in a1 if going use xldown. there has @ least 1 more value in column or traverse bottom of worksheet. better bottom of worksheet upwards , offset 1 row down.

with sheets("database")       'primarily use database worksheet     if .filtermode .showalldata     .cells(rows.count, 1).end(xlup).offset(1, 0) 'look bottom down 1 row         'direct value transfer faster copy, paste special, values         .cells.resize(1, 8) = sheets("entry form").range("e10:l10").value     end end  sheets("entry form")     'primarily use entry form worksheet     .range("e10:l10").clearcontents 'clears data drop down selections     .range("e10").select            'returns selection date entry box end

this makes use of with ... end statement control worksheet receiving attention. see how avoid using select in excel vba macros more methods on getting away relying on select , activate accomplish goals.


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