hi!

try this to copy specific range of cell

Range("A9:N9").Select
Selection.Copy
Application.CutCopyMode = Fals

--
sujata_ghos
-----------------------------------------------------------------------
sujata_ghosh's Profile: http://www.excelforum.com/member.php...fo&userid=1643
View this thread: http://www.excelforum.com/showthread.php?threadid=27796