开发者

How to activate a cell based on another cell value?

Using A1, I change the value of A2, I'd like it will automatically activate cell (F3, F56, F109... so on). I'm newbie in script programming. Thank you

`

    function onedit(e) {
        var sh = e.range.getSheet();
        var A2 = sh.getRange("A2开发者_运维技巧").getValue();
    sh.setActiveRange(sh.getRange(A2)).activate() 
    }

`

`

hide/show rows and columns in google sheet script so slow... I want a faster method to try.
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜