Reading in cell values as long as they is something there and naming it.

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.

If you can afford to insert a row temporarily at the top of the sheet you could try this.
(CODE)
By the way, have you considered naming the entire range 'Finish'?
Then you could refer to the individual

Is there a way the include a spot for my procedure that I need to do on each Finish? Perhaps I do not need to name each one? I need to gather some data on each one of the Finishx values. And at the end delete the name/s from the Name Manager. I need the name stored in a cell or in a name to grab it, but I also need to get back to it and check the next one.

Or perhaps a For Selection loop might work better? Does a For Selection work on a horizontal range? Range starts at B1, but I need to know what name was assigned to the selection when reading it, so I can write that name out when gather data on it. Hope this makes sense.

Featured Post

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code)
David miller (dlmille)
Intro
Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation)
David Miller (dlmille)
Synopsis
In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …

Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…

This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.