software

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 quot;BLANKquot; cells
datafilled with the word NULL.

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

....Mike

Enter this macro:

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

Select the cells you want to change and run the macro.
--
Gary's Studentquot;msbutton27quot; wrote:

gt; Hey all,
gt;
gt; I found that you can auto fill blank cells by going to EDIT/GOTO/SPECIAL,
gt; etc...
gt;
gt; but when I do this Excel reports the range is to large, I have 39,000 Rows
gt; and approximately 37 Columns and I need a way to have all the quot;BLANKquot; cells
gt; datafilled with the word NULL.
gt;
gt; Is there a way or is Excel limited to a specific spreadsheet size?
gt;
gt; ...Mike

Maybe you could do it in smaller chunks.

specialcells has a problem when you get over 8192 separate areas in it (IIRC).

msbutton27 wrote:
gt;
gt; Hey all,
gt;
gt; I found that you can auto fill blank cells by going to EDIT/GOTO/SPECIAL,
gt; etc...
gt;
gt; but when I do this Excel reports the range is to large, I have 39,000 Rows
gt; and approximately 37 Columns and I need a way to have all the quot;BLANKquot; cells
gt; datafilled with the word NULL.
gt;
gt; Is there a way or is Excel limited to a specific spreadsheet size?
gt;
gt; ...Mike

--

Dave Peterson

I was able to break the 39,000 rows into a more specific criteria of 2000 -
then the EDIT/GOTO function worked perfectly...

Thanks...

....Mike

quot;Dave Petersonquot; wrote:

gt; Maybe you could do it in smaller chunks.
gt;
gt; specialcells has a problem when you get over 8192 separate areas in it (IIRC).
gt;
gt; msbutton27 wrote:
gt; gt;
gt; gt; Hey all,
gt; gt;
gt; gt; I found that you can auto fill blank cells by going to EDIT/GOTO/SPECIAL,
gt; gt; etc...
gt; gt;
gt; gt; but when I do this Excel reports the range is to large, I have 39,000 Rows
gt; gt; and approximately 37 Columns and I need a way to have all the quot;BLANKquot; cells
gt; gt; datafilled with the word NULL.
gt; gt;
gt; gt; Is there a way or is Excel limited to a specific spreadsheet size?
gt; gt;
gt; gt; ...Mike
gt;
gt; --
gt;
gt; Dave Peterson
gt;