Joerg

Little easier method.............

At step #4 hit CTRL + ENTER to add the word to all selected blanks.


Gord Dibben MS Excel MVP

On Fri, 25 Aug 2006 18:13:41 +0900, "Joerg" wrote:

Why do you need a macro?
1) Select your column up to the last entry
2) Push F5 -. Special - Blanks (this will select all blank cells in your
previous selection)
3) Add your number, word or whatever
4) Push ENTER to go to the next blank cell

Cheers,
Joerg