Hey,

I am trying to use a macro to get my excel worksheet to number
automatically (the rows)....however when i insert a row, the number
tracking is off and there is no automatic numbering...

This is the code I am using:

Sub Autonumber()
done = 0
X = 2
Do While done < 1
If (Cells(X, 1) = "") Then
entry = X - 1
done = 1
Else
X = X + 1
End If
Loop

Cells(X, 1) = entry
X = entry + 1


End Sub

Can anyone please help me ASAP!!!

THANKS :)

Munny Khera