Enter this macro:

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

Select the cells you want to change and run the macro.
--
Gary's Student


"msbutton27" wrote:

Hey all,

I found that you can auto fill blank cells by going to EDIT/GOTO/SPECIAL,
etc...

but when I do this Excel reports the range is to large, I have 39,000 Rows
and approximately 37 Columns and I need a way to have all the "BLANK" cells
datafilled with the word NULL.

Is there a way or is Excel limited to a specific spreadsheet size?

...Mike