我尝试为前5行创建一个带有冻结窗格的电子表格。我让它创建一个excel电子表格,但出于某种原因,我的冻结窗格只冻结前2行和前2列。
With objExcelAssist.worksheet
Dim xlApp As Object
Set xlApp = objExcelAssist.Application
xlApp.ActiveWindow.FreezePanes = True
End With
我试过:
Dim rv As Object
Dim rng As Object
Set rng = rv.Range(rv.Cells(4, 2), rv.Cells(4