Selecting cell ranges only with text using a macro

L

lykwid

Hi,

I would like to select only the cells with text inside in a specifie
column, and then define them with a name.

For example, my data starts at cell B5. How would I select all th
cells with data from B5 to Bx and then define them with a name?

Thanks. :
 
D

Dave Peterson

Select B5 to B(whatever).

Edit|goto|Special

Now your choices begin. If you mean text (like constants), check that option
button. You can even limit it to numbers/text/logicals (True/False)/errors.

Now with those cells selected, you can use
Insert|name|Define
to give it a nice name.

(Or you could just type the nice name into the namebox (to the left of the
formula bar) and make sure you hit enter!)
 
L

lykwid

Thanks for the suggestion.

But I now realise I didn't actually say what I wanted. :)

I would like the name I have defined to cells B5 to Bx to be extended
automatically when a new piece of data is added under Bx. This data is
added when a user uses a data entry form.

Is it possible to automatically extend the name range?

Thanks.
 
Top