Calc macro: how to create range (columns) with row number as variable

[Translating-IT]

Hi,

I have a macro that stores the row number of the last changed cell within column K in the variable oRow.

I now want to create a range from columns A to AB for that row in order to automatically convert formulas to values within that range.

In theory it would be creating a range by concatenating ‘A & oRow’ to ‘AB & oRow’.

How can I achieve this in the macro in Basic.

Best regards,
Pascal

[elmau]

Doc = ThisComponent
Sheet = Doc.Sheets(0)
oRow = 100
Rango = Sheet.getCellRangeByName("A" & oRow & ":AB" & oRow)
MsgBox Rango.AbsoluteName