If condition inside a for loop

Hi guys,

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.
Thanks
Ronanvba error.pngMacrosRD - V3.xlsm

Hi !

Only one On Error Goto codeline is necessary !

But by checking array variable Data size via UBound function, you don't need any !

Are you sure of G column ? In Sheet1 that's Quantity ! …

Bonsoir Marc et merci!

G5 down to the end is used to count how many rows there are. The variable is taken from Rng.beg E1.

I know that only one Go to Error is necessary but tonight I was so desperate that I tried that ... and duh it did not work

Thank you for your help.

Ronan

Mama mia ‼

In your piece of code, RngBeg variable is G5 cell.
So With Wks.Cells(r, RngBeg.Column) codeline is relative to Worksheet "Sheet1" column #7 aka G so Quantity !
'Cause this column is numeric, can't have two minus signs inside … So are you sure of G column ?!

I understand your point. Though, I have been using this code for the last 4 month and it worked perfectly. The only difference is that the column that is being looked at has now empty cells due to a change in my software.
Tomorrow i will attach to this thread a data file that I run the macro on. It will make more sense.

In fact your code seems to work but just 'cause of On Error Goto codeline ! A waste of process time …

Alright, attached is a data file that I use on a daily basis.
When I run it I use the MacroV3 file that contains my database then I open the file with all the gross data.

When running the macro Dailyreport we have an error due to the column of GL Accounts that is without value. w29.xlsx

'Cause of code bad conception, you must explain the purpose of the Dailyreport procedure !
For example, ActiveSheet means which worksheet of which workbook ?

Error ? Which one ? Message ? In which codeline ?

Read post #2, you already have a way to avoid it …

Marc,

The code is not perfect and its conception has been evoluting with the help of numerous people here, though I am not sure we can talk about bad conception.

I was able to place the relevant line code On error Resume Next and it works now.

Thank you for your help anyway.

Ronan

A well code conception does not need multiple On Error Goto statement like in yours …
And so many ways to avoid it !

This statement just hides problems, not resolves them …

And one day you should ask on a forum like many others :
« I don't understand, my code does not work but there is no error message ! » …