I am encountering an issue again with the program I have been developing for the last couple month and hopefully i will find good help.
I have a For loop that looks Inside a range of cells, depending on the value it gives me a data kept Inside the database. This being said, I have cells that are empty and so it displays an error.
I tried to put in the loop an IF function to check the empty condition but it does not work. I also tried to Go To Next R on Error but failed again.
This is on the Macro "Dailyreport" right before line 505.
The main goal is to ignore the empty cells and move to the next line. It looks pretty simple on paper but I struggled for 2 days on that thing.
Any help would be awesome.
Ronanvba error.pngMacrosRD - V3.xlsm