Creating a macro loop in Excel 2000?

Question

I would like to create a macro loop in Excel, so that I don't have to constantly change a program line with the description of a new item. I have setup small macros in the past, to automate my spreadsheet. If I have a column of items say from cell A1TO A100, and want to do a carry for each one to my criteria, and then carry the results to a specific location, what would the exact program lines be. I know it is an (if then, else combination), also a (goto statement involved) but I need a specific example, as I have had not much luck setting up this macro. I would appreciate anyone's help concerning this matter

Thank You

Answer 1

The text of the macro would be

For Count = 1 to 100
If Cells(Count,1) = Criteria then Cells(Count,2) = Result
Next Count

Answer 2

Sub Example()

Range("a1").Select

For L = 1 To 100
If ActiveCell.Offset(L, 0) = "your criteria" Then _
ActiveCell.Offset(L, 4) = ActiveCell.Offset(L, 0)

Next

End Sub

Answer 3

for i = 1 to 100
if cell("A" & i)=whateveryour criteria is then
cell("D" & i)=whatever you want put in there
end if
next i

(you don't need a goto)

Answer 4

You'd want to use a for loop. Start with this:

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Dim firstRow, lastRow, curRow as integer

firstRow = inputBox("Enter the first row")
lastRow = inputBox("Enter the last row")

For curRow = firstRow to lastRow

Next curRow

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''


Then put your actions in between the For and the Next statements.