I want to write a macro that checks each row of a spreadsheet & does some
data validation then goes to the next row. The statements I have are nested
& are too long to put directly in the cells. How can I write a macro that
does this?

I know how to write the validation statements. It is the bit where it
checks a row then goes to the next row that I am stuck on. The spreadsheets
will be of variable number of rows. TIA
--
Tony