Button macro to dynamically fill in blank cells in Table with zeros

[alexcon]

Greetings, I've got a defined table in excel (when you convert a range into an actual Table).

I need a button macro to dynamically fill in all blank cells of the Table with zeros even if we add more rows and columns later- then rerun the macro.

 

[My Aswer Is This]

Try this:
Assumes your Table is named "Table1"

Sub Fill_Table()
Application.ScreenUpdating = False
Dim c As Range
    For Each c In ActiveSheet.Range("Table1")
        If c.Value = "" Then c.Value = 0
    Next
Application.ScreenUpdating = True
End Sub

 

[Fluff]

Another option

Sub BlanksToZero()
Range("[COLOR=#ff0000]Table2[/COLOR]").SpecialCells(xlBlanks).Value = 0
End Sub

Change table name in red to suit

 

[alexcon]

Thank you both, the solution works great!

 

[My Aswer Is This]

Glad we were able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thank you both, the solution works great!