O$. Counting Excel lines

[Brian O'Sullivan]

Hi Jacques,
I don’t have experience using automation, but the COUNTA() function is useful for this purpose. Could you use automation to create a cell-formula using COUNTA() over the desired range of rows, and then read in the value result? Just a thought!

regards,
-brian o’sullivan

> On Mar 20, 2017, at 5:50 AM, Jacques Zemron <jacky at aec-ri.com> wrote:
> 
> Hello everybody,
> 
> does anyone know how to know the count of lines not empty in Excel Sheet with automation ?
> 
> regards,
> 
> Jacques ZEMRON
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com