EXCEL里VB编辑器中的下标越界问题
以下是一段代码,按F8逐条运行到给ENDROW1赋值时提示下标越界,请问是什么原因?
Dim sheetsCaption1 As String: sheetsCaption1 = "Sheet5"
Dim Col As String: Col = "B"
Dim StartRow As Integer: StartRow = 2
Dim EndRow1 As Integer: EndRow1 = Sheets(sheetsCaption1).Range(Col & "65536").End(xlUp).Row