vba初学,编译出错提示:子过程或函数未定义,程序代码如下
vba初学,编译出错提示:子过程或函数未定义,程序代码如下
日期:2011-07-09 22:09:18 人气:4
Sub sn()
Dim z1, z2, z3 As Long
Dim i, cd As Integer
cd = Sheets.Count
z1 = 0
z2 = 0
z3 = 0
For i = 2 To cd
Sheet2.Cells(i, 2).Value = Sheets(i).Name
If i < cd Then
For m = 2 To Sheets(i).Range("A65536").End(xlUp).Row
If Sheets(i +