Get Value From Cell

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?

Please Login or Register  to view this content.

But like Winon mentioned, I guess you want the result pasted somewhere.
Where oh where will that be though

Thank the both of you for a response. What my long term goal is to read the cell value (which I now have examples of doing such) and use that as the worksheet name to hyperlink to. I am googling on how to do this exactly, but I see that it can be done. My data is similar to this set-up
Blue 16

So I have a worksheet named Blue - and I want the number 16 to be a hyperlink to the worksheet Blue.

This is invalid syntax, but how would I modify it to work?

Please Login or Register  to view this content.