Forum Discussion
Fixing vba code that replaces empty columns with dates.
I'm working on some VB projects that has to do with generation of new excel sheets and some data analysis. In the final sheet generated, there are some columns that contain excel default dates (00.0...
The problem is with the line where you add two cells together. If those cells are empty, the addition (+ sign) forces Excel to use the default numerical value of an empty cell, which is zero. SO the result of adding two empty cells is always a zero.
