Add names to blocks

**jgmiddel** · 10-09-2008, 08:34 AM

Hi, can anyone help me with the following:

In a worksheet I have (not equal) blocks of data. In column A there is the projectnumber, in columns B-K there are data. Projects are devided by an empty row. All rows in some block have in column A the same value (projectnumber).
What I need is the following: I would like to add names to that blocks. The name must be equal to the projectnumber.
Thanks for helping!

**gurusanthanam** · 10-09-2008, 08:55 AM

Place the Cursor in the block and use Ctrl+A to select the entire block (single Block) and again press Ctrl+F3 to define the names.

Go To next block and do the same....

Hope it solves your problem....

Regards,
guru

**jgmiddel** · 10-09-2008, 08:59 AM

Funny, guru...

. I need a macro for it. Otherwise I wouldn't have had post it in 'programming'.

**rwgrietveld** · 10-09-2008, 09:00 AM

Please Login or Register  to view this content.

**jgmiddel** · 10-09-2008, 09:23 AM

Thanks a lot, but it doesn't seem to work. No names are added to my worksheet.

**rwgrietveld** · 10-09-2008, 09:34 AM

Should have added my worksheet. Sorry for that. Note that it is a quick and dirty method, adjust it so you'll like it. As you did not add a worksheet you need to customize it anyhow.

**jgmiddel** · 10-09-2008, 10:02 AM

Ah, I see what happened. If the value a cell in column A doesn't start with 'proj' the macro skips the value. Is there a way it will pick all sort of values?

**jgmiddel** · 10-09-2008, 10:23 AM

OK, I found out what was going wrong. If the projectnumber contains only digits or starts with a letter, it will not work. Problem is solved so far.
But, I need to add some row wich places "Proj" before all values in column A. Of course, when it's there already, skip it.