FiveTech Software tech support forums

Posted: **Wed Dec 15, 2021 4:38 am**

Guys:
How can i do that?

Thanks

Posted: **Wed Dec 15, 2021 5:21 am**

I have to look into my crystal ball ...
but I don't see a solution with so little information.

Posted: **Wed Dec 15, 2021 5:56 am**

Jimmy wrote:I have to look into my crystal ball ...
but I don't see a solution with so little information.

I want to freeze rows in Excel
For example, the first two lines of My Excel sheet are frozen

Posted: **Wed Dec 15, 2021 9:30 am**

From recorded macro

Code: Select all | Expand

Sub Macro1()
'
' Macro1 Macro
'

'
    With ActiveWindow
        .SplitColumn = 0
        .SplitRow = 1
    End With
    ActiveWindow.FreezePanes = True
End Sub

Posted: **Thu Dec 16, 2021 1:40 am**

I solved this way

Code: Select all | Expand


oWin := oExcel:ActiveWindow
oSheet:Cells( 2, 1 ):Select()
oWin:FreezePanes := .t.

FiveTech Software tech support forums

freeze rows in excel RESOLVED

freeze rows in excel RESOLVED

Re: freeze rows in excel

Re: freeze rows in excel

Re: freeze rows in excel

freeze rows in excel RESOLVED