Excel oddity

[Bob Umlas]

Open two separate sessions of Excel.
Put any data in A1:B10
Hide rows 2:9
Select A1:B10, use goto special/Visible cells only.
Copy
In a 2nd sheet of same workbook, paste. You get what you expect.
In a sheet from the 2nd session of Excel, Paste. You DON'T get what you expect.

Any good explanation of why the difference?

[Jesse]

This works correctly if you open excel and create a new workbook from within.

When you open excel twice from the start menu it opens in a separate instance and you lose some functionality when you try to go between the two and you can't access macros from workbooks in the other instance.

Not really sure why this is or what the limitations are, I would be interested in understanding it as well.

Jesse

[Bob Umlas]

Actually, you CAN access macros in the other instance - mainly need to set a reference to it. However, what you did was reiterate the oddity -- I did say it works fine in the same instance, but odd in a 2nd instance.

[Jesse]

Yes, I did reiterate only I said second workbook in the same instance vs second worksheet.

Forum is new, I was looking for excuses to post. Didn't intend to offend.

[Bob Umlas]

:-) -- I wasn't offended.

[Zack Barresse]

Let me preface with, "Bob, I have no idea."

Perhaps it's a different clipboard of the two, and special cells do not get passed the same. Have you tried other types of special cells? I haven't, but will in a little bit.

[Bob Umlas]

Figured it was a different clipboard but still falls under the category of "oddity", IMHO

[Zack Barresse]

Absolutely. I wouldn't expect you to find anything less.

[Ken Puls]

Absolutely. I wouldn't expect you to find anything less.

LOL!

Interesting though... if you're using Excel 2010, right click the sheet in the second workbook and choose Paste Special -> Match Destination Formatting. It gives you what you'd expect. So obviously, clipboard differences or not, the original selection is still held somewhere.

I would agree that the default should match with the original Excel instance though.

[Jon Peltier]

It's the old Windows Clipboard - Excel Clipboard thing, isn't it?