excel - Need to know why Method Range of Object Worksheet Failed Error is occuring -


the idea of code below few tables, match headers 2 different tables , move answers 1 table next.

the method range of object worksheet failed happening on find function:

@ colforanswer = ws.range(rngcollookup).find(curcell, lookin:=xlvalues, searchorder:=xlbyrows, searchdirection:=xlnext).column.

i have searched on , cannot find solutions solve problem. can please me understand why not working.

thank you!

sub submitresponses()  'find question name, grab answer column of table row, match question column, place answer 'view scoring functions if needed  'redefine named range of column headers , search  dim rngheaders range dim rngappq range, rngappq2 range, rngcollookup range dim rngappanswer range, rngappanswer2 range dim integer dim ws excel.worksheet dim answerarea integer dim colforanswer integer dim curcell variant  set ws = thisworkbook.worksheets(appsheet)  set rngappq = worksheets(atable).range("tappinfo" & "[[#all],[questions]]") set rngappanswer = worksheets(atable).range("tappinfo" & "[[#all],[answers]]") set rngappq2 = worksheets(atable).range("tappinfo2" & "[[#headers]]") set rngappanswer2 = worksheets(atable).range("tappinfo2") set rngcollookup = worksheets(appsheet).range(apptable & "[[#headers]]")  debug.print rngcollookup.address  answerarea = ws.cells.find("*", searchorder:=xlbyrows, searchdirection:=xlprevious).row + 1  each curcell in rngappq  debug.print curcell debug.print rngcollookup.address  colforanswer = ws.range(rngcollookup).find(curcell, lookin:=xlvalues, searchorder:=xlbyrows, searchdirection:=xlnext).column ws.cells(answerarea, colforanswer).value = curcell  next  end sub


Comments

Post a Comment

Popular posts from this blog

android - net_scheduler holding wakelock -

i have observed on occasions, net_scheduler keeps acquiring wakelock repeatedly on short durations , prevents android device sleep. from logcat, not able obtain conclusive information why might happening. of gms services active. can suggest when there higher chance occur perspective of gms services. this seems coming gcmnetworkmanager , schedules network-oriented tasks, google play services able batch network operations across system. also if use more advanced scheduling firebase jobdispatcher , internally gcmnetworkmanager used.
Read more

sql - MySQL : Getting Entries from a many-to-many table -

i have following table, select records should have mentioned values. example select companyid should have 3 providerid 200,300,400. running query should retrun companyid 2. opposite of in . in advance ! companyid | providerid -------------------------------------- 1 100 2 200 3 500 4 600 2 300 2 400 7 100 do group by , select rows of 3 wanted employeeid values. use having make sure 3 different employeeid values. select companyid tablename employeeid in (200, 300, 400) group companyid having count(distinct employeeid) = 3 another approach double self join, 1 each employeeid. however, less flexible: select distinct t1.companyid (select companyid tablename employeeid = 200) t1 join (select companyid tablename employeeid = 300) t2 on t1.companyid = t2.companyid join (select companyid tablename employeeid = 400)...
Read more

java - Retrieving data from database using jsp (Hibernate + Spring + Maven) -

hello, guys. i'm trying retrieve data oracle database, nothing appears on screen. here userslist.jsp <%@page contenttype="text/html" pageencoding="utf-8"%> <!doctype html> <html> <head> <title>spring mvc hello world</title> </head> <body> <h2>all users in system</h2> <table border="1"> <tr> <th>user id</th> <th>login</th> </tr> <c:foreach items="${users}" var="user"> <tr> <td>${user.userid}</td> <td>${user.login}</td> </tr> </c:foreach> </table> </body> </html> it seems ok. , here spring controller userscontroller.java package com.controller; import com.database.users; import com.service.usersmanager; import java.util.list; impo...
Read more