vba - Excel Do While Find -

-

below code uses .find function in excel find location dodcell appears in sheet2 , add reecell column 18 in sheet2 sheet1. suppose loop based on how many times finds strsearch in rrange.

but, running once , stops, think there mistake in "do while loop" can't seen fix it.

any thoughts?

so after fixing errors pointed out in code have revised sub. think have addressed loop issue, know program running once , freezing excel , need restart excel. think have created infinite loop don't know how fix ideas?

     sub addnumber()     'used add ree value dod projects     dim ssht worksheet, dsht worksheet     dim lastrow integer     dim firstaddress string     dim strsearch string     dim reecell range, dodcell range, arange range, rrange range, aarange range     dim hold1cell range, holdcell range, lastcell range     set ssht = worksheets("sheet1")     set dsht = worksheets("sheet2")     set rrange = ssht.columns(18)     set arange = ssht.columns(1)     set aarange = dsht.columns(1)     lastrow = ssht.range("a" & rows.count).end(xlup).row     strsearch = "2*"
  
    set dodcell = rrange.find(what:=strsearch, lookin:=xlvalues, _                     lookat:=xlpart, searchorder:=xlbyrows, searchdirection:=xlnext, _                     matchcase:=false, searchformat:=false)     'if dodcell holds value enter loop     if not dodcell nothing         'set lastcell dodcell         firstaddress = dodcell.address                             'set reecell value of ree number                     set reecell = dodcell.offset(0, -17)                     'set holdcell cell holds dod number in "sheet2"                     set holdcell = aarange.find(what:=dodcell, lookin:=xlvalues, _                                     lookat:=xlwhole, searchorder:=xlbyrows, searchdirection:=xlnext, _                                     matchcase:=false, searchformat:=false)                     'set hold1cell location ree value should                     set hold1cell = holdcell.offset(0, 9)                     'give hold1cell ree # reecell                     hold1cell = reecell.value                     set dodcell = rrange.findnext(dodcell)          loop while not dodcell nothing , dodcell.address <> firstaddress     end if end sub

i think while loop may working correctly. looks problem code alters cell contents not within loop well. set dodcell, change value of based on find, , loop find next dodcell, , address of (set dodcell = rrange.findnext, etc.), exit loop , sub.

try moving of other code loop , see if expected results.


Comments

Post a Comment

Popular posts from this blog

ios - UICollectionView Self Sizing Cells with Auto Layout -

-
Image
i'm trying self sizing uicollectionviewcells working auto layout, can't seem cells size content. i'm having trouble understanding how cell's size updated contents of what's inside cell's contentview. here's setup i've tried: custom uicollectionviewcell uitextview in contentview. scrolling uitextview disabled. the contentview's horizontal constraint is: "h:|[_textview(320)]", i.e. uitextview pinned left of cell explicit width of 320. the contentview's vertical constraint is: "v:|-0-[_textview]", i.e. uitextview pinned top of cell. the uitextview has height constraint set constant uitextview reports fit text. here's looks cell background set red, , uitextview background set blue: i put project i've been playing on github here . updated ios 9 after seeing github solution break under ios 9 got time investigate issue fully. have updated repo include several examples of different configurations s
Read more

node.js - ldapjs - write after end error -

-
i have created authentication service using following code in node.js , ldapjs. var when = require ('when'); var authenticationerror = require('../errors/authenticationerror'); var sessionmanagerservice = require('./sessionmanagerservice'); var ldap = require('ldapjs'); var client = ldap.createclient({ url: 'ldaps://ad.mycompany.com:636', tlsoptions: {'rejectunauthorized': false} }); module.exports = { signin: function (email, password) { return this.ldapbind(email, password).then( function () { return sessionmanagerservice.createsessionhash({email: email}); } ); }, ldapbind: function (email, password) { var deferred = when.defer(); client.bind(email, password, function(err) { if (err) { deferred.reject (new authenticationerror('invalid username and/or password!', 'authentication.signin.error')
Read more

DOM Manipulation in Wordpress (and elsewhere) using php -

-
DOM Manipulation in Wordpress (and elsewhere) using php - i'm quite new dom manipulation world , head start in order avoid mutual errors. i looking efficient way manipulate content generated wordpress using php. @ moment using simple html dom seems work fine. found domdocument , few others , helpfull if cleared out 1 faster, improve or @ to the lowest degree generate less errors in case of bad markup. also on side can explain syntax (instead of $html @$html) thank much php wordpress domdocument simple-html-dom
Read more