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

iLastRow = Cells(Rows.Count,"A").End(xlUp).Row
For i = 1 To iLastRow
'do the validation on Cell(i,"A")
Next i

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"TonyL" wrote in message
...
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

Thanks for that. One more question. How to I get a statement that checks a
cell in the current row. TIA
--
Tony


"Bob Phillips" wrote:


iLastRow = Cells(Rows.Count,"A").End(xlUp).Row
For i = 1 To iLastRow
'do the validation on Cell(i,"A")
Next i

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"TonyL" wrote in message
...
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

This checks for column R in the active cell's row

If Cells(Activecell.Row,"R").Value = "something" Then
...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"TonyL" wrote in message
...
Thanks for that. One more question. How to I get a statement that checks
a
cell in the current row. TIA
--
Tony


"Bob Phillips" wrote:


iLastRow = Cells(Rows.Count,"A").End(xlUp).Row
For i = 1 To iLastRow
'do the validation on Cell(i,"A")
Next i

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"TonyL" wrote in message
...
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