Cannot paste between two different instances of Excel

Hi,

I am having trouble pasting between two spreadsheets in different instances of Excel.

I am copying a range of cells and then attempting to paste using ctrl + v/ right-click + paste in a workbook in the other instance of excel. It just selects the area where the cells would be pasted but nothing appears.

The only way I can get it to work is by using the clipboard task pane and clicking paste from there however this isn't a long term option as I need to code this into a macro. I also don't understand why there is a difference between pasting from the clipboard panel and pressing 'ctrl v'.

There are not macros running at the time and pasting into another program e.g. notepad works fine.

Any help would be greatly appreciated.

Rob

Hi,

Did you try paste values?

I guess the data in the range of cells you are trying to copy' is result of a formula. Then you should use paste values.

Copy the range of cells --> select the cell you want to paste --> click paste --> paste values

See if this works, else let know.

----------------------------------------------------------------------------------------
If my reply helped, Don't forget to add to my reputation (click on the star below the post)
If the reply solves your problem, Don't forget to mark the thread as "Solved" (Thread Tools->Mark thread as Solved)