for each ws in sheets/ for each xcell in range

[lezawang]

Hi
I see these code like below and I wonder what is the rule? or how people came with this? or what is the syntax.
For example

dim ws as worksheet
for each ws in sheets

or

dim xcell as cells
for each xcell in range

Thank you.

 

[Michael M]

What rule ?
It's just simply an abbreviation of Worksheets / Cells.
You could also use


dim w as worksheet
for each w in sheets

so you don't have to say "worksheets" every time, you say "w"

 

[lezawang]

Thank you very much for your reply. No I did not mean the WS, Xcell etc. I meant the For loop. I know the For loop like this

For x = 1 to 100

But to say "For each ws in worksheets" is something I do not understand? I mean I understand the meaning but How people come with this idea? Same apply for the cell for example

For each xcell in range

Thank you

 

[Michael M]

For x = 1 to 100....is simply using x as a variable integer

For each ws in worksheets...is using ws as an object worksheet among ALL the worksheets.

Beyond that, I don't know how else to explain it.

 

[Fluff]

Have a look here
https://www.excelcampus.com/vba/for-each-next-loop/

 

[lezawang]

Thank you all for this great help

 

[Fluff]

You're welcome & thanks for the feedback