SOLVED

Excel office script - ctrl + shift + end

New Contributor

Hello everyone,

 

Is there an interface or alghoritm to select the range that I would get if I were to click CTRL+ SHIFT + END. I would need the rightmost column and downmost row that contains data(at least a single non-empty cell). 

 

1 Reply
best response confirmed by Jovankk (New Contributor)
Solution
Worksheet object's .getUsedRange() method helped my case