Quote Originally Posted by GhostofDoom View Post
p45cal, i see when we import from a new file
we get the same ID numbers ?

any solution for that please
Change:
.Cells(1) = 1
to:
.Cells(1) = .Cells(1).Offset(-1).Value + 1