求助!!!!!!!
Private Sub confirm_Click()
Dim m1 As Range, n As Long
Set m1 = Sheets(4).UsedRange
'n代表当前表格最后一行数据的下一行
n = m1.Row + m1.Rows.Count
Range("A", n) = teachernames.Value
Range("B", n) = textComboBox1.Value
Range("C", n) = textComboBox2.Value
Range("D", n) = modules.Value
Range("E", n) = faculty.Value
Range("F", n) = teacher_id.Value
'将窗体中输入的数据清除,等待下次输入
teachernames.Value = ""
textComboBox1.Value = ""
textComboBox2.Value = ""
modules.Value = ""
faculty.Value = ""
teacher_id.Value = ""
Unload Me
End Sub
这个总是显示 “range作用与_global 是出现错误”
我把range("A",n) 改成 range(“A”,cstr(n)) 也不行
请问这是为什么?