[Erel]

You can use IsNull to first check if the value is null.

If IsNull(Table1.Cell(Table1.ColName(k),0)) Then myVar = 0 else myVar = Table1.Cell(Table1.ColName(k),0)