Selecting cell ranges only with text using a macro

  • Thread starter Thread starter lykwid
  • Start date Start date
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. :
 
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!)
 
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.
 
Back
Top