Display active cell

[alkinnon]

Hi,

I have a spreadsheet with a Macro to select the last empty position in a column; however, I then have to manually scroll to find that active cell.

A keyboard shortcut accessible via macros that would move the sheet to display the active cell would be extremely useful for large sheets and save extensive scrolling time.

Or perhaps an activeCell.View() command?

Thanks for your time,
Al

[Constantine]

Hello @alkinnon

I believe you are describing similar scenario from this topic:

Set Focus to Cell

Hello everybody, I’m currently working on a set of macos for worksheets. I set formulars to cells etc. But funnily I’m stuck with a quite simple problem (so it seems). After processing several cells, I’d like to set the focus (activate) a particular cell. I tried something like: var oWorksheet = Api.GetActiveSheet(); oWorksheet.GetRange("B1:B1"); But that does not set the focus to the specified cell. Can anybody help?

Is that correct?

[alkinnon]

Hi @Constantine, and thanks for your response.

Setting focus would be giving a cell the active cursor for editing. I’m already doing that successfully by selecting a single cell range with:

range = activeSheet.getRangeByNumber(row, col)
range.select();

While I can focus on the target cell, it remains offscreen until I scroll the spreadsheet to find it.
I want to see the cell on screen, perhaps centred in the spreadsheet`s container?

Thanks again for your response,
Al

[alkinnon]

After reading through the entire post I see that it does look the same. My apologies

[Constantine]

Thank you very much for the update and your interest. I will forward your query to the existing enhancement then. Once any news come up, I’ll inform you.