Hello
I dont have a lot of knowledge about VBA so i would like to ask if someone can fix my code so that it will work as it should :D
i will add a excel workbook with the first sheet where there are informations needed for the if statment.
I want my code to start in cell G1 and go down to the last row where there is a value and then offsets itself to the first blank.
After that it should go to the left to the column C where the date and activate the cell, my logic which is flawed then wanted to check with If statment
if in cell one to the left of active cell in this case would be B4 is bigger then a value in cell B3 it should put a value of 0 in other cell
else do something else :D
The problem with my code is that my if statment dosent work
the code is :
Any suggestions or advice how to better set the code would be also most wellcomed.
Bookmarks