Stop Macro from running after certain row?

Hello I am trying to use a macro that links data from one sheet in a workbook to another sheet, and drags the formula across the rows.
Currently I have my macro repeating to the final row in the sheet, but I would like it to stop at at specific row. for example row 74.
Here is the code I am using:

Please Login or Register  to view this content.

I am using Excel 2010. Please help

Maybe change this line:

For i = 6 To FinalRow

To this line:

For i = 6 To 74

John is correct. Another option would be to put an If statement within the loop which checks the current row of "i". If it is >73 you would exit the sub. Depending on what you wanted to do this could be more useful or more of a hinderance.

Balston: FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
is wrong. You have 1 instead of l in (xlUp)

Try this one

Please Login or Register  to view this content.

Thanks so much for all your answers! I actually just tried putting
Final row= 74 and it worked! Go figure.