freeze rows in excel RESOLVED

Post Reply
artu01
Posts: 400
Joined: Fri May 11, 2007 8:20 pm
Location: Lima

freeze rows in excel RESOLVED

Post by artu01 »

Guys:
How can i do that?

Thanks
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
User avatar
Jimmy
Posts: 1740
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany
Has thanked: 2 times

Re: freeze rows in excel

Post by Jimmy »

I have to look into my crystal ball ...
but I don't see a solution with so little information. :(
greeting,
Jimmy
artu01
Posts: 400
Joined: Fri May 11, 2007 8:20 pm
Location: Lima

Re: freeze rows in excel

Post by artu01 »

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

:P


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
hmpaquito
Posts: 1482
Joined: Thu Oct 30, 2008 2:37 pm

Re: freeze rows in excel

Post by hmpaquito »

From recorded macro

Code: Select all | Expand

Sub Macro1()
'
'
Macro1 Macro
'

'

    With ActiveWindow
        .SplitColumn = 0
        .SplitRow = 1
    End With
    ActiveWindow.FreezePanes = True
End Sub
artu01
Posts: 400
Joined: Fri May 11, 2007 8:20 pm
Location: Lima

freeze rows in excel RESOLVED

Post by artu01 »

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
Post Reply