Hi Ian,

When the For staement is executed, the current value value of lastrow is
retained as a counter for i for the whole of the For-Next loop.

Try using a counter in DO - LOOP UNTIL lastrow counter.

Regards,
Don

"nicoll" wrote in message
...
Can anyone help me please with this macro.

If I add a row to a spreadsheet I want to increment the final value in a
for
statement but it doesn't seem to work.

ie

For i = 4 To lastrow

(if statement which can add a row)
lastrow = lastrow + 1
Else: End If
next i


When I run this lastrow doesn't increment and last row stays at the
original
value.

Thanks

Ian