Counting items in a loop

[ShawnTMc]

Excel newbie here,

This is most likely going to be an easy one to answer.

I'm just trying to figure out how to count the number of items the following loop successfuly goes through. I'm looking to create a message box at the end of this loop to show how many items were saved. Something like " (item count number) Excel Documents Extracted."

This is what I have so far.

----------------------------------------------------

 

[Rick Rothstein]

Dim a variable as Long for counting, say N for this example. It will default to a value of 0. So, inside your inner For..Next loop, put this line of code...

N = N + 1

That way, ever loop, the N variable will increase in value by 1. So, at the end of the code, before it ends, put a MessageBox statement that displays N.

 

[ShawnTMc]

Dim a variable as Long for counting, say N for this example. It will default to a value of 0. So, inside your inner For..Next loop, put this line of code...

N = N + 1

That way, ever loop, the N variable will increase in value by 1. So, at the end of the code, before it ends, put a MessageBox statement that displays N.

Thank you Rick. That's exactly what I was looking. I was trying to figure it out logically but I couldn't grasp how the loop would know to store the count value in "N".