[Solved] Macro to GOTO a Cell using Row:Column NUMBERS?

[alf50]

Does anyone have an example Macro to GOTO a cell that I have just written a Number In. All the examples seem to use Row/Column ID's like A5, rather than the equivalent X,Y coordinates of the Cell (IE: 0,4)?

[FJCC]

There is a getCellByPosition() method. A macro would look like

Code: Select all

oSheets = ThisComponent.Sheets
oSheet = oSheets.getByName("Sheet1")
oCell = oSheet.getCellByPosition(0,4)

I'm not sure that you need to Go To (that is, select) that cell. There is no need to select the cell for most macro purposes.

[JohnV]

To have oCell become the active one add this line to FJCC's code.

Code: Select all

ThisComponent.CurrentController.Select(oCell)