SOLVED

Excel office script - ctrl + shift + end

Copper 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 (Copper Contributor)
Solution
Worksheet object's .getUsedRange() method helped my case
1 best response

Accepted Solutions
best response confirmed by Jovankk (Copper Contributor)
Solution
Worksheet object's .getUsedRange() method helped my case

View solution in original post