i trying perform action see if date in range (daterng) less today's date, , then, if is, perform loop hide rows w.here value in column zero. (i paying off loans, , every month want hide loans have been paid off.) months across columns, loans in rows. loan balance (i, j). the problem never exits loop go , check date after every new 'j' (column). stays in loop. have tried break, exit, continue, etc. none seem work, @ least place them. how check date, compare 'today', run loop check each cell in column, before moving on column 2, checking date , performing same loop. it have dynamic, not necessary, every month change ranges in code. strictly personal use. appreciated. thank you. sub hidepaid() dim day range, loanrng range, loansum worksheet, daterng range, cel2 range, long, j long, col range set loansum = thisworkbook.worksheets("loan sum") loansum.activate set daterng = activesheet.range("d2:r2") set loanrng = activesheet.range("d