If I have two work sheets open in teh same instance of excel and I copy from one to the other and use the "Paste Special" function I get a screen with the option to paste ALL, FORMULAS, VALUES, etc.
If I try the same paste to an excel sheet in another instance of excel, (Useing two monitors) I get a totally diffrent options screen. Paste as a MS Office excel worksheet object etc.
In a nut sheel I am trying to past data from one spread sheet to the other and copy the source formating.
Any thoughts for me??