Guest User

Untitled

a guest
Jan 21st, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.66 KB | None | 0 0
  1. For crow = 1 To 100
  2.  
  3. Value = Worksheets("Movies_categories").Range("A" & crow).Value
  4. cat_final = Worksheets("Movies_categories").Range("B" & crow).Value
  5.  
  6. If Value = "y" Or Value = "Y" Then
  7.  
  8. 'Loop for reading the data from tabsheet- Movies
  9.  
  10. For crowss = 5 To 3000
  11. movies_cat1 = Worksheets("Movies").Range("B" & crowss).Value
  12. movies_language = Worksheets("Movies").Range("C" & crowss).Value
  13.  
  14. If movies_language = "English" Then
  15.  
  16. Temp = Split(movies_cat, ",") 'run time Error:10 occurs here..
  17.  
  18. For Each boken_c In Temp
  19. flag = 0
  20. boken_c = Trim(boken_c)
  21.  
  22. If RTrim(LTrim(boken_c)) = LTrim(RTrim(cat_final)) Then
  23. flag = 1
  24. GoTo Line4:
  25. End If
  26. Next boken_c
  27. End If
  28. Next crowss
  29. End If
  30. Line4: Next crow
  31.  
  32. For crow = 1 To 100
  33.  
  34. Value = Worksheets("Movies_categories").Range("A" & crow).Value
  35. cat_final = Worksheets("Movies_categories").Range("B" & crow).Value
  36.  
  37. If Value = "y" Or Value = "Y" Then
  38.  
  39. 'Loop for reading the data from tabsheet- Movies
  40.  
  41. For crowss = 5 To 3000
  42. movies_cat1 = Worksheets("Movies").Range("B" & crowss).Value
  43. movies_language = Worksheets("Movies").Range("C" & crowss).Value
  44.  
  45. If movies_language = "English" Then
  46.  
  47. Temp = Split(movies_cat, ",") 'run time Error:10 occurs here..
  48.  
  49. For Each boken_c In Temp
  50. flag = 0
  51. boken_c = Trim(boken_c)
  52.  
  53. If RTrim(LTrim(boken_c)) = LTrim(RTrim(cat_final)) Then
  54. flag = 1
  55. **Exit For**
  56. End If
  57. **If flag = 1 Then Exit For**
  58. Next boken_c
  59. End If
  60. **If flag = 1 Then Exit For**
  61. Next crowss
  62. End If
  63. Next crow
  64.  
  65. Call Sub1(gArray(3))
  66. debug.print gArray(3)
  67. ...
  68. Sub Sub1(i as integer)
  69. Redim gArray(0)
  70. End sub
  71.  
  72. Sub Sub1(ByVal i as integer)
  73.  
  74. If StrComp(Mid(s, 1, lE), txtE, vbBinaryCompare) = 0 Then
  75. For i = iMdl To 1 Step -1
  76. With blks(i)
  77. If .lnEnd = 0 Then ' ".lnEnd" is a member of blks(i)
  78. .lnEnd = ln
  79. GoTo NXT
  80. End If
  81. End With
  82. Next
  83. errBegWith = errBegWith & ln & ", "
  84. NXT:
  85. End If
  86. '...
  87. ReDim Preserve blks(iMdl)
  88.  
  89. If StrComp(Mid(s, 1, lE), txtE, vbBinaryCompare) = 0 Then
  90. For i = iMdl To 1 Step -1
  91. If blks(i).lnEnd = 0 Then
  92. blks(i).lnEnd = ln
  93. GoTo NXT
  94. End If
  95. Next
  96. errBegWith = errBegWith & ln & ", "
  97. NXT:
  98. End If
  99. '...
  100. ReDim Preserve blks(iMdl)
Add Comment
Please, Sign In to add comment