How to fill in "BLANK" Cells Automactically...Large Spread Sheet
Maybe you could do it in smaller chunks.
specialcells has a problem when you get over 8192 separate areas in it (IIRC).
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
--
Dave Peterson
|