VBA - For Each Loop - Cannot check all cells in range if first cell is not populated

Hi there,

I am relatively new to VBA and I am trying to create some validation rules for a data entry sheet end users will be populating.

I am using a For Each loop to verify the data in a particular column. The code below works if the cells are populated in order (top to bottom). However, if I copy and paste multiple incorrect values into the range at once, or if I populate a cell further down in the range leaving the top cell blank, the validation only works for the first cell in the range and does not loop through.

I cannot seem to make this work without being stuck in a continuous error loop. Is there a better way to do this?

Any advice would be appreciated!

Please Login or Register  to view this content.

Welcome to the board.

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with CODE tags.

Thanks.

EDIT: Thank you.

I can't tell from your code what behavior you want; can you clarify?

Please Login or Register  to view this content.

** No sample file = no check tsk, tsk, tsk