hi..thanks sharon for your help..
how to modify the codes to copy a few rows to anoher worksheet
--
new_to_vb
-----------------------------------------------------------------------
new_to_vba's Profile:
http://www.excelforum.com/member.php...fo&userid=3013
View this thread:
http://www.excelforum.com/showthread.php?threadid=49858