开发者

How to activate a cell based on another cell value?

开发者 https://www.devze.com 2022-12-07 18:11 出处:网络
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

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

精彩评论

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

关注公众号