fill blank cells in a column

On 19 Nov, 13:21, Gary''s Student
wrote:
> Select the part of the column you want to fix and:
> Edit > Goto > Special > Blanks
> after typing the stuff, finish with CNTRL-ENTER rather than just the ENTER
> key.
> --
> Gary''s Student - gsnu2007k

"selection is to large"



thanks anyway
 >> Stay informed about: fill blank cells in a column 

Then here is a macro solution:

First select the block of cells you want to fill. The macro will ignore any
cells in the block that are not empty.

Then run this macro:

Sub fillEmpty()
Dim r As Range
For Each r In Selection
If IsEmpty(r) Then
r.Value = "luis"
End If
Next
End Sub



Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To use the macro from the normal Excel window:

1. ALT-F8
2. Select the macro
3. Touch Run



To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

[URL="http://www.mvps.org/dmcritchie/excel/getstarted.htm"]http://www.mvps.org/dmcritchie/excel/getstarted.htm[/URL]
 >> Stay informed about: fill blank cells in a column