How to determine row/column extent of spreadsheet?

[cyrille de brébisson]

Hello,

This is a hard one!
Obviously, the spreadsheet does keep that data internally, but as you noted, there is no user accessible variable that lets you access it...

I had a look at the source code and here is the trick.
When you extract a full row or column, it returns a list which size IS the max row/col count!

So, SIZE(A:A) gives you the number of rows and SIZE(1:1) the number of columns!

Not very efficient, but will work.

Regards,
Cyrille