|
1005423860 发表于 2016-3-2 13:41
你好,我还想问一下 Set NY = Rows(1).Find(what:="年份", lookat:=xlWhole, LookIn:=xlValues) 如果只 ...
若sheet2-sheet7格式一样,则:
Sub HZ()
......
Set NY = Sheets(2).Rows(1).Find(what:="年月", lookat:=xlWhole, LookIn:=xlValues)
C = 1: N = 1
Do
C = C & "," & NY.Column
Set NY = Sheets(2).Rows(1).FindNext(NY)
Loop Until NY Is Nothing Or NY.Column = N
P = Split(C, ",")
......
End Sub
|
|