Get row count of all worksheets

Help
, ,
1

I have an Excel file which has new sheet names every week. I’d like to return the sheet name & also a count of all the rows in each sheet.
I can pick up the sheet names, but I can’t seem to use rows.count or any variation of that.

Has anyone got a solution?

Thanks!

2

Hi ,
Can you please check this. It May help you.

File : Get row count of all worksheets.zip (9.5 KB)

Regards
Balamurugan.S

3 Likes
3

Thank you!
Worked perfectly

4

Nice … :slight_smile:

5

Is there a way to write this to a file rather than a write line?
When i try, it seems to overwrite A1 in an Excel

6

Yes, you can use write cell activity.

Regards
Balamurugan.S