great, very thanks but i aslo get 1 little question more :)

1) your code delete OK, but deleted rows is not up. It mean it keep
orgianal position.
2) and now, pls help me, i wanna del from rows 2 to end of rows in
database
because the first row is title, man, :))
thank you very much for help


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=565629