Code: Select all
Sub move
Dim oSheet as Object
Dim oCell as Object
oSheet = ThisComponent.CurrentController.getActiveSheet()
oCell = oSheet.getCellRangeByName("A1")
oCell.setValue(123)
End Sub
I would like an understanding of this behaviour as I think it might be useful for avoiding bugs when I come to write macros.