well the given code snippet wanders to Cell B5 and then deletes the contents ... something similar and for all your three Cells does

'all is the sum of all css.sheet.CellFlags
all = 895
xSheet = ThisComponent.Sheets(0)
xCellRange = xSheet.getCellRangeByName("B5")
xCellRange.clearContents(all)
xCellRange = xSheet.getCellRangeByName("B7")
xCellRange.clearContents(all) xCellRange = xSheet.getCellRangeByName("B11") xCellRange.clearContents(all)
Hope that helps

Thanx, this help me a lot, but the problem is that I thought the Macro recorder did it itself. I selected various cells in a macro and it created the code I sent you before. Instead I want it do something similar that you say.

I use this code. But I want to know if it's a bug and if it can be solved easily.

Thanx a lot

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to