dutch wrote:Dear Mst.Rao and Maurizio,
I got another problem for ::nFreeze. If you scroll to right until the column hide under freeze, the :cExpr will show incorrected.Maurizio wrote:I use
cField := oBrw:aCols[oBrw:nColSel]:cExpr
Maurizio
cField := oBrw:SelectedCol():cExpr
Maurizio wrote:I use
cField := oBrw:aCols[oBrw:nColSel]:cExpr
Maurizio
oWin := oExcel:ActiveWindow
oSheet:Cells( 2, 1 ):Select()
oWin:FreezePanes := .t.
Sub Macro1()
'
' Macro1 Macro
'
'
With ActiveWindow
.SplitColumn = 0
.SplitRow = 1
End With
ActiveWindow.FreezePanes = True
End Sub
Jimmy wrote:I have to look into my crystal ball ...
but I don't see a solution with so little information.