|
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Row = 9 Then
Call autoAutoFill("b9", "47018", "d3", "扫描记录")
End If
End Sub
Sub autoAutoFill(ByVal Range1 As String, ByVal Sh1 As String, ByVal Range2 As String, ByVal Sh2 As String)
Dim Lie As Integer
Lie = Range(Range2).Columns
Dim Hang As Integer
Hang = Sheets(Sh2).Cells(65536, Lie).End(xlUp).Row + 1
Sheets(Sh2).Cells(Hang, Lie).Value = Sheets(Sh1).Range(Range1).Value
End Sub
我想达到的要求是,当第9行改动时,把47018工作表中的b9列里的数据复制到扫描记录工作表里d3所在列里的第一个空白单元格里面,可是运行是提示溢出。什么意思》是不是没有写对,还是哪儿要改正一下~请帮忙改正一下,谢谢~~
|
|