Get Value From Cell

[jo15765]

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?

[Winon]

Hello jo15765,

I am needing to capture the text from all the cells in column B. Sample data reads like this

Where do you want to capture the text to, or where or how would you like it displayed?

[jolivanes]

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

[Winon]

You could also have it like this,

Please Login or Register  to view this content.

[jo15765]

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.

[jo15765]

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

Please Login or Register  to view this content.