VBA code to sum value of column

[Carl Clements]

Hi,

I need some code that works out the sum of a column, before applying an IF statement. There is text in cell 1 of the columnm which I'm unsure if that will cause a problem.

My failed attempt is below. Can anybody help?

If Sum(ActiveCell.Column) = 0 Then
End If
Else
Call ZUCSD_NAVSUMM_Diff_Message

Thanks,
Carl

 

[VoG]

Try

If WorksheetFunction.Sum(ActiveCell.EntireColumn) = 0 Then

 

[Andrew Poulsom]

Try:

If WorksheetFunction.Sum(ActiveCell.EntireColumn) = 0 Then