Fill cell that is blank
Another method
1. Select the sheet upto your need
2. Press Ctrl+H
3. Leave the Find what box blank
4. Enter your words at Replace with box
5. Click Replace All button
Bingo....
thanks
Shail
Gord Dibben wrote:
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
|