Reading in cell values as long as they is something there and naming it.
Posted on 2014-04-22
Starting at cell B1, there is a value there. I would like to read that value and name it for future use. Move one cell to the right, check it for a value, if one is there read the value, name it, and move to the right as long as there is a value.
Example: B1 is 123_456, name that Finish1, cell C1 is 456_789, name that Finish2 and so on until it finds a blank cell.
I need to use Finish1, Finish2 .... in a different procedure, but wanted to read all the values at once and name them.
How would I do this is VBA?