update macro when new data is added to a table

[sharky1978]

Hi all

im new to macros, i have a macro that add 0 to blank cells,

my question is how to i get it to look at new data that is added to the table as min only does the initial area i set. i have added what i have at the moment

Sub add0_to_FGHI()
'
' add0_to_FGHI Macro
' will add 0 to col fghi
'

'
Range("F2,F2:F25,G2:G25,H2:H25,I2:I25").Select
Range("I2").Activate
Selection.Replace What:="", Replacement:="0", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2
End Sub