Problem with combining For Each and If Then statements

It's been some time since I did any sort of programming.

Please Login or Register  to view this content.

What I want to do I filter out meaningfull cells from meaningless cells, cells with a value of 0 are meaningless everything els is meaningfull. The meaningfull cells are copied to a different sheet to be proccesed again.

So in line 2 I start moving trough my selected ranges, if the value = 0 then I want to move to the next cell, but Excel gives the following error in line 4 "Next without For" and if I change it to End If so it skips line 5 it gives the error " End If without block If"

So I looked up why it was giving that error, what I found was that after the If Then structure you give a statement but witch statement to use to go to the next cell or a different solution ofc

Greetz & Thanks Jotje.

Kopieer alle zinvolle gegevens naar kolom AD
Copy all relevant data to column AD

Please Login or Register  to view this content.