Can't understand why xl is changing the destination sheet to hidden. I have a hidden data file that I regularly copy from into unhidden sheets without the problem you seem to be having. (I'm running XL97 sr2 on NT4). For what its worth I've attached a sample code below.
' Select copy range from hidden workbook/worksheet
' Select destination range
' Paste to selected destination
>>> "Gafford, William L" <[log in to unmask]> 19/03/01 >>>
Anybody got any idea why Microsoft set up Excel so that when data is
copied from a hidden worksheet and then pasted into another worksheet, the
destination worksheet is hidden?? Seems to me that this is a bug, because
I'm not copying and pasting the worksheet, I'm copying and pasting a data
range from a hidden worksheet. That shouldn't hide the destination
The information contained in this message and any attachments are intended solely for the use of the individual or entity to whom they are addressed. It may contain privileged or confidential information. If you are not the intended recipient you must not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the sender. Thank you.
This email message has been swept by MIMESweeper for the presence of known computer viruses.