『求教』如何在EXCEL文件里编写一段宏可以在工作表里插入一行!
我看OFFICE 里的帮助,,照抄如下代码,可是总是在
Set objList = wrksht.ListObjects(1) 这行代码位置提示下标越界,我上网查了,关于这方面的资料实在太少了,,哪位大侠可以帮忙啊?
Function ActivateInsertRow() As Boolean
Dim wrksht As Worksheet
Dim objList As ListObject
Dim objListRng As Range
Set wrksht = ActiveWorkbook.Worksheets(1)
Set objList = wrksht.ListObjects(1)
Set objListRng = objList.InsertRowRange
If objListRng Is Nothing Then
ActivateInsertRow = False
Else
objListRng.Activate
ActivateInsertRow = True
End If
End Function