changing range to range in row immediately below in a loop

my objective is to do data validation for all cells in columns B through E in which there is a value in column A. i am able to get it to do the first row, but when it comes to changing the range to be used (B:E) i cannot seem to get it to adjust for the row that it is in. i think the fix is relatively simple i just cannot think of it. any ideas?

Please Login or Register  to view this content.