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.
精彩评论