I am at a loss for how to make the =concatenateIf function work in my vba when it's on a loop. I'm pulling info from one tab to another to do quarterly reporting. I need to concatenate 4 cells to another tab, but only if the cell isn't blank. What I have now is to concatenate the 4 cells with a semi-colon separator. If I have 4 columns with info in the 1st and last column, but the middle columns are blank, it shows like this: Saturday;;;Tuesday instead of Saturday;Tuesday. I need it to skip the blank columns so the separator semi-colon won't show. I found this concatenateIf function, but I can't figure out how to get it to work in a loop. Below is my current code. I have tried to call the function, but I don't know how to do it. Any help would be greatly appreciate it. Thanks!

Please Login or Register  to view this content.