Forum Discussion

Brass Contributor

Mar 02, 2023

Loop Through Worksheets and Counts Populated Rows

I want to create a macro that I can run each week. I have a workbook and on the first worksheet I want to count how many populated rows there are on the other worksheets. So in this example I want a...

excel

Formulas and Functions

Macros and VBA

dscheikey

Bronze Contributor

Mar 04, 2023

ClaireMcF

I can't write the macro for you. But I have a suggestion to try it with a function.

If B2 contains the name of the worksheet. For example, "Andrew_Mohan". Then:

=IFERROR(COUNTA(INDIRECT(B2&"!A2:A40")),"")