excel - mismatch error for sheetname -

-

i wondering why keep facing mismatch error

if (sheets(newsheetname).rows(l).cells(1, 2).value = product) then

the code trying figure out , match cells , loop across different worksheets.

see below code :

    dim range1, range2 range     'define variables     dim referencesheetcols integer     dim range1rows, range1cols, range2rows, range2cols, testrows, testcols, i, j, p long     dim bmatches, rowmatched   boolean     dim product string      product = "producta"     newsheetcols = 2123     referencesheetcols = 2123     ' how many rows , columns should compare?     testrows = 1     testcols = 7     p = sheets(referencesheetname).usedrange.rows.count     l = 7 newsheetcols         'only test if correct product          **if (sheets(newsheetname).rows(l).cells(1, 2).value = product) then**             rowmatched = false             k = 7 referencesheetcols                 'bmatch = false                 set range1 = sheets(referencesheetname).rows(k)                 set range2 = sheets(newsheetname).rows(l)                 ' count rows , columns in each of ranges                 range1rows = range1.rows.count                 range1cols = range1.columns.count                 range2rows = range2.rows.count                 range2cols = range2.columns.count                 'are ranges same dimension?                 bmatches = (range1rows = range2rows , range1cols = range2cols)                 'if same dimensions loop through cells                 if bmatches                     = 1 testrows                         j = 1 testcols                             if (range1.cells(i, j).value <> range2.cells(i, j).value)                                  bmatches = false                                  = testrows                                  j = testcols                             end if                         next                     next                 end if                 if bmatches                     rowmatched = true                     k = referencesheetcols                 end if                 'sheets(outputsheetname).cells(1, 1).value = rowmatched                 if (not (rowmatched) , k = referencesheetcols)                     range2.copy                     sheets(outputsheetname).range("a1:a6000").cells(p, 1).offset(2, 0).select                     activesheet.paste                     p = p + 1                 end if             next         end if     next end sub

to complete question inline guidelines, 

if cstr(sheets(newsheetname).rows(l).cells(1, 2).value) = product             rowmatched = false             k = 7 referencesheetcols

Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5&quo
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name&qu
Read more

javascript - Chrome Extension: Interacting with iframe embedded within popup -

-
i writing chrome extension needs interact urls user not have open. therefore using hidden iframes embedded within popup, , attempting click button within iframe. however, receiving same origin policy error. know possible extension interact iframes of different domain via content scripts when iframe on tab user has open, not sure if possible use content scripts interact iframes directly in popup. here code: manifest.json "content_scripts": [ { "js": [ "bin/jquery.min.js", "interaction.js" ], "all_frames": true, "run_at": "document_start", "matches": [ "http://*/*", "https://*/*" ] }], "permissions": [ "activetab", "tabs", "http://*/", "https://*/" ], interaction.js $(document).ready(function() { $('div#iframes').append("<iframe id='shop' src=
Read more