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...
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...
Read more

javascript - How to Hide Date Menu from Datepicker in yii2 -

-
basically in datetimepicker widget date choose first time, how can hide date option widget , filter according time. tried not working want hide remove button [ 'attribute'=>'time', 'label'=>'time', 'format'=>'raw', 'value'=>function($data){ return date('h:i:s',strtotime($data->time)); }, 'filter'=> datetimepicker::widget([ 'model' => $searchmodel, 'attribute' => 'time', 'clientoptions' => [ 'autoclose' => true, 'format' => 'hh:ii', 'showon' =...
Read more