I am needing to capture the text from all the cells in column B. Sample data reads like this
Blue
Red
Green
Pink
Orange

Psuedocode would be
Get value from B2
Debug.Print value
Next value

What is VBA syntax for this?