freeze rows in excel RESOLVED

[artu01]

Guys:
How can i do that?

Thanks

[Jimmy]

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

[artu01]

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

[hmpaquito]

From recorded macro

Code: Select all  Expand view

Sub Macro1()
'
' Macro1 Macro
'

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

[artu01]

I solved this way

Code: Select all  Expand view

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