<p>老师帮看一下</p><p>Sub 显示()<br/>Dim arrSource(2 To 3, 1 To 10) As String<br/>Dim c, d, i As Integer<br/> For c = 2 To Range("a65536").End(xlUp).Row<br/> arrSource(2, c) = Cells(c, 1)<br/> arrSource(3, c) = Cells(c, 2)<br/> If Left(arrSource(2, c), 7) = arrSource(3, c) Then<br/> Cells(c, 3) = "有"<br/> Else<br/> Cells(c, 3) = "无"<br/> End If<br/> Next<br/> <br/>End Sub</p><p>================================</p><p><font color="#ff0000">呵呵,你除了声明数组那一步是体现出数组外,其他的都不是用数组的解法,单元格赋值给数组和数组赋值给单元格都没掌握。再努力。</font></p><p><font color="#ff0000"> --------------uranus1997</font></p>
[此贴子已经被uranus1997于2008-7-2 7:51:29编辑过] |