Sub GenXin()
Dim I As Long
I = Me.Range("C1048576").End(xlUp).Row
Me.Range("O3:AI3").AutoFill Destination:=Me.Range("O3:AI" & I), Type:=xlFillDefault
Me.Range("O4:AI" & I).Formula = Me.Range("O4:AI" & I).Value
Me.Range("AL3:AS3").AutoFill Destination:=Me.Range("AL3:AS" & I), Type:=xlFillDefault
Me.Range("AL4:AS" & I).Formula = Me.Range("AL4:AS" & I).Value
Me.Range("AU3:CR3").AutoFill Destination:=Me.Range("AU3:CR" & I), Type:=xlFillDefault
Me.Range("AU4:CR" & I).Formula = Me.Range("AU4:CR" & I).Value
End Sub
高手帮忙把这段代码分析解释下,每一句代码都分别什么意思,控制什么?谢谢!
Dim I As Long
I = Me.Range("C1048576").End(xlUp).Row
Me.Range("O3:AI3").AutoFill Destination:=Me.Range("O3:AI" & I), Type:=xlFillDefault
Me.Range("O4:AI" & I).Formula = Me.Range("O4:AI" & I).Value
Me.Range("AL3:AS3").AutoFill Destination:=Me.Range("AL3:AS" & I), Type:=xlFillDefault
Me.Range("AL4:AS" & I).Formula = Me.Range("AL4:AS" & I).Value
Me.Range("AU3:CR3").AutoFill Destination:=Me.Range("AU3:CR" & I), Type:=xlFillDefault
Me.Range("AU4:CR" & I).Formula = Me.Range("AU4:CR" & I).Value
End Sub
高手帮忙把这段代码分析解释下,每一句代码都分别什么意思,控制什么?谢谢!