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)
Worksheet object's .getUsedRange() method helped my case