Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fill in "BLANK" Cells Automactically...Large Spread Sheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fill in "BLANK" Cells Automactically...Large Spread Sheet
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fill in "BLANK" Cells Automactically...Large Spread She
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 "Dave Peterson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
vlookup on large text in cells | Excel Worksheet Functions | |||
Still can select locked cells in protected sheet | New Users to Excel | |||
Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
is it possible to select and change the values of cells in a minimized excel spread sheet from vba? | Excel Worksheet Functions |