write a function to run the same row in excel

i=0// intializing i because err may find any row inside the table

while (table= err)

button1.click()

button2.click()

if message box. exist then // some scenario's  a meaasge box appears

checkbox.click()

button3.click()

end if

wend

i=i+1

1.if implemented this and the if statement is not getting executed.

2.if i comment  the if statement  the loop goes on and never ends

somewhere i go wrong