Help with a macro
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 |
Help with a macro
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 |
Help with a macro
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 |
Help with a macro
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 |
All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com