Forum Discussion
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...
Hi, ClaireMcF .
There are some possible reasons for an error at this line of code. Could you please send an image of the error message?
One of the possible problems is the error 6 (overflow), which will happen if we have an empty Sheet or if you have a specific Sheet with a large number of rows (more than 32,767 rows). Can you confirm if you have any of these cases in your file?
Thanks so much - I don't have an empty sheet but when I ran the code for the first time it jumps to the 'Mohan' worksheet and settles on row 1048576 and I get the 6 (overflow) error that you mention below. So I deleted the empty rows from row 3 to row 1048576 and ran the code again. Same thing happens, and the cursor settles on Mohan, row 1048576. Thankyou