Hi guys,

I'm struggling to fix this and i can't find a way to go ahead.

I have to fix two things in this dataset:

1) including a check that skips "expired" and "null" lines from a loop

Copy of benchmark UK expansion fix.xlsm

In the attached you will see that there is a module that duplicates line from GANNT sheet into EXPANDED PERIODS times the value of duration cells. GANNT sheet is populated with another module from another source (that i had to remove to have 1MB file). When the sub breakSeasonality runs, it stops when the first row contains "expired" or "null" values. I need to add a string that checks if there are such values and if yes skips the line until a good one is found.

I've tried to put something but i miserably failed

Hope i can get your help