Problem: Trying to copy, paste special and transpose a range of cells from one file to another. If the cells I want to copy, etc., in the source file (i. e., the file from which I want to copy) contains numbers or letters (as opposed to references to other cells), everything is ok. However, whenever source cells have a reference to another cell, wen I try and paste special|transpose, I get blanks for each cell that has such a reference when I paste special|transpose the cells into the target file. Any ideas?
Thanks in advance.