Ok, this sounds a little simple, but it's bothering me this morning.
Yesterday (all day) I worked with two workbooks; one had multiple rows of
calculated fields, in a format of:
A1
A2
A3
A4

I was able (yesterday) to select A1:A4, copy (Ctrl+C) then tab over to the
other workbook, select one cell (double click) and then paste the contents of
A1:A4 into that one cell. I did it all day.

This morning I opened the same files and it doesn't work; every time I
double click on the destination cell I loose my reference to the selected
rows. Is there an option somewhere that I'm missing?

Thanks!