Grab the Free VBA Quick Reference Guide
https://chrisjterrell.com/p/getting-s...
If a
1) A For doesn't have a next
A next doesn't have a for
2) A Do doesn't have a Loop
a loop doesn't have a do
3) A While doesn't have Wend
or a Wend doesn't have a why.
Sounds confusing watch the video it will make more sense