Running MAC macros on PC

[VandyGrantLab]

I recorded and wrote macros in Mac Excel 2004, and I would like to use them on a PC, but they don't work because of differences in how the clipboard holds information when you copy and paste (I think ). I've searched online, and seen a fix for a specific instance, but I was wondering if you can somehow change the way the clipboard works for Excel on a PC, so that it acts like the clipboard in Mac Excel 2004. Any advice would be greatly appreciated!

 

[VandyGrantLab]

In case it helps, the VB error message I receive reads as follows:

Run-time error '1004':

Paste method of Worksheet class failed


Thanks again!!!!