Up until today I was able to copy and paste a range of data from one
worksheet to another worksheet in a different file. Now whenever I try to
highlight a range, press Ctrl C , mouse over to the other worksheet, and do
Ctrl V or click on Paste,
the Range where I am copying into is blanked out. Is there a known bug in
Excel 2007 related to the Copy and Past functionality. I have been working
with old and new spreadsheets and never had this problem until today. Please
shed some light. Thank you.