Albert,
l_row must be converted to a string -
OleApp.Rows(TRANSFORM(l_row) + ":" + TRANSFORM(l_row)).Select
-Dan
>Hello Everybody
>
>How to select rows,columns,cells with parameters ?????
>
>I create a excel worksheet from my cursor (simplified example)
>l_row = 1
>l_col = 1
>select cursor
>scan
> OleApp.Cells(l_row,l_col).Value =xxxx
> l_row = l_row + 1
> .
> .
> .
>
> if .....
> l_col = l_col +1
> i_row = 1
> endif
>endscan
>
>Now i want to format a block of rows or columns or cells in my scan
>
>This would be the excel syntacs:
>
>Oleapp.Rows("3:3").Select
>Oleapp.Selection.Font.Bold = .T.
>Oleapp.Selection.Font.size = 12
> >I don't know how to pass parameters to the select line
>Oleapp.Rows("l_row:l_row").Select does not work !
>
>
>Any help welcomed
>Best regards
>Albert