Forum Discussion
Fixing vba code that replaces empty columns with dates.
I'm working on a VBA project and I have series of macro codes attached to an excel sheet that generates more excel sheets after. The project consists of 3 stages and my issue has to do with the 3rd s...
Fatman003 I expect the issue is with this line:
ws_ta.Cells(cpt, col_ter_tache + 3).Value = AAA_TOOL_QN_Lib.DetermineWeek(ws_ta.Cells(cpt, col_ter_tache).Value)
If the function AAA_TOOL_QN_Lib.DetermineWeek returns a zero value, or with this one:
ws_ta.Cells(cpt, len_d + 2).Value = str_date
if str_date equals zero.