Braunschweiger
Board Regular
- Joined
- Feb 19, 2014
- Messages
- 104
I'm tying to make sure I understand the code below which is part of one or my loops.
QUESTION: Where you see End(3) -- what does the "3" stand for?
QUESTION: Where you see End(3) -- what does the "3" stand for?
VBA Code:
For i = 9 To Range("B" & Rows.Count).End(3).Row
- "i" could be anything...correct? It's just common to use "i".
- 9 simply starts the loop at the 9th row...correct?
- "B" self explanatory...points to the second column or, column "B"
- "Rows.Count" counts the rows starting at the 9th row in column "B"
- Regarding "Rows.Count" - what other code could be substituted for "Count"...what else could "Rows.?????" be used for?
- "End" - why do we need to include "End"?
- And finally, what does the "3" stand for?