Guys:
How can i do that?
Thanks
freeze rows in excel RESOLVED
freeze rows in excel RESOLVED
Last edited by artu01 on Thu Dec 16, 2021 1:41 am, edited 1 time in total.
fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql
Re: freeze rows in excel
I have to look into my crystal ball ...
but I don't see a solution with so little information.
but I don't see a solution with so little information.

greeting,
Jimmy
Jimmy
Re: freeze rows in excel
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
fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql
Re: freeze rows in excel
From recorded macro
Code: Select all | Expand
Sub Macro1()
'
' Macro1 Macro
'
'
With ActiveWindow
.SplitColumn = 0
.SplitRow = 1
End With
ActiveWindow.FreezePanes = True
End Sub
freeze rows in excel RESOLVED
I solved this way
Code: Select all | Expand
oWin := oExcel:ActiveWindow
oSheet:Cells( 2, 1 ):Select()
oWin:FreezePanes := .t.
fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql