hi Kristy,

Try this if the sheet is password protected.

Insert a blank sheet.
cut paste your data in this sheet.

then try coping from here to the target sheet.

Post the file on excelforum.com or mail the file to me on



Regards,

sam


--
sanskar_d
------------------------------------------------------------------------
sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217
View this thread: http://www.excelforum.com/showthread...hreadid=379199