excel - VBA - Comparison anomalies using variant -

-



i have found couple of other questions dealing variants none of them seem address issue.

i have simple loops doing comparisons. purpose color excel cell red if there isn't match. results 99% accurate, have noticed couple of seemingly random errors. example, cell containing number 104875 not colored red, indicates there should matching cell in comparison column. there isn't. seems should wrong or correct. of other threads variants have mentioned comparisons have of same type or weird errors. in case, of same type (both integers), isn't problem.

i brand new vba , still trying understand how works.

this relevant part of code:

private sub commandbutton1_click()  dim long, j long dim flag boolean dim array1() variant, array2() variant dim column1 double dim column2 double  column1 = convertcolumn(textbox1.text) column2 = convertcolumn(textbox2.text)  set wb1 = workbooks("advocate july 2017 data.xlsm").sheets(1) set wb2 = workbooks("bi report 8-18-17.xlsm").sheets(1)  array1 = intersect(wb1.columns(column1), wb1.usedrange) array2 = intersect(wb2.columns(column2), wb2.usedrange)   = 2 ubound(array1)     flag = false     j = 2 ubound(array2)         if isnumeric(array1(i, 1)) , isnumeric(array2(j, 1)) if cdbl(array1(i, 1)) = cdbl(array2(j, 1)) flag = true         next j     if not flag wb1.cells(i, column1).interior.color = vbred next end sub

edit: turns out code works fine. problem of cells on 1 of sheets hidden , didn't realize it. ~facepalm~ that's being inexperienced in excell

try simplify code, reproductible. e.g., lets want compare first 50 cells in columns a , b in activesheet. put values , this:

option explicit  public sub testme()      dim array1      variant     dim array2      variant     dim           long     dim j           long     dim flag        boolean      activesheet         array1 = .range("a1:a50")         array2 = .range("b1:b50")         .range("a1:a10").interior.color = vbwhite          = lbound(array1) ubound(array1)             flag = false              j = lbound(array2) ubound(array2)                 if array1(i, 1) = array2(j, 1) flag = true             next j              if not flag .cells(i, 1).interior.color = vbred         next      end  end sub

then try adapt solution yours. should work.





wiki

Comments

Post a Comment

Popular posts from this blog

Asterisk AGI Python Script to Dialplan does not work -

-
i'm stuck project have check database of sip extension incoming caller id , dial sip extension. below receive when run script on asterisk cli. -- registered sip '9125' @ 192.168.1.102:50142 > saved useragent "zoiper rv2.8.40" peer 9125 [2017-08-22 13:53:33] notice[5095]: chan_sip.c:24558 handle_response_peerpoke: peer '9125' reachable. (17ms / 2000ms) == using sip rtp tos bits 184 == using sip rtp cos mark 5 -- executing [0112617769@from-trunk:1] answer("sip/obitrunk1-0000000d", "") in new stack > 0x1ca50d0 -- probation passed - setting rtp source address 192.168.1.98:16834 -- executing [0112617769@from-trunk:2] agi("sip/obitrunk1-0000000d", "test.py") in new stack -- launched agi script /var/lib/asterisk/agi-bin/test.py args: ['/var/lib/asterisk/agi-bin/test.py'] env line: agi_request: test.py env line: agi_channel: sip/obitrunk1-0000000d env line: agi_language: en env line: a
Read more

python - Read npy file directly from S3 StreamingBody -

-
i have many .npy (numpy) , .json files saved in s3, need download , load these files. for json files downloading files , loading dictionary using following code: obj = s3.object(bucket, key) response = obj.get() body = response['body'].read().decode('utf-8') data = json.loads(body) that way avoid writing .json file disk , reading it. now want same .npy files, equivalent? currently downloading file, saving temp file on disk , loading np.load avoid if possible. following https://stackoverflow.com/a/28196540/3509999 : obj = s3.object(bucket, key) io.bytesio(obj.get()["body"].read()) f: # rewind file f.seek(0) arr = np.load(f) wiki
Read more

kotlin - Out-projected type in generic interface prohibits the use of metod with generic parameter -

-
i start using kotlin , defined interface this: interface aadapter<vh : recyclerview.viewholder> { fun oncreateaviewholder(parent: viewgroup): vh fun onbindaviewholder(v: vh, position: int) } and when try use on code: class klasa ( private val adapter: aadapter<*> ) { fun dosth(){ //... val vh = this.adapter.oncreateaviewholder(parent) //on below line error adapter.onbindaviewholder(v, position) //... } } i error out-projected type 'aadapter<*>' prohibits use of 'public abstract fun onbindaviewholder(v: t, position: int): unit i tied add "in" or "out" definition i'm confused. how allow it. replace aadapter<*> aadapter<recyclerview.viewholder> . class klasa ( private val adapter: aadapter<recyclerview.viewholder> ) { // ... because have declared aadapter has type parameter vh type subclass of recyclerview.
Read more