Forum Discussion
Macro works on windows but stopped working on Mac and messes up the result
Hello, hope you can help me please. I have a macro written on a windows computer but being used on a Mac. At first the macro's worked perfectly but then all of a sudden started doing sometime very strange.
It copies the heading from column A onwards and enters it in column O onwards and then when I have my next vendor change it copies some of the data from the last vendor and adds it above the above line of incorrect data also starting from column O onwards.
Your help would be much appreciated.
Thank you
Zander
1 Reply
- Regarding paths... with a high probability it could be because of that.
- As far as I know, not all Win Excel functions are available on Mac Excel. So if a macro object or command refers to something that doesn't exist in Mac Excel, then of course it doesn't work.
- Differences in UserForm Controls Win Excel / Mac Excel
- Differences in the object model
- Differences in the AddIns
- VBA control of the menu bars
- Differences in reading and writing
- Differences in charts
...certainly one or the other difference, depending on the version, has been corrected, but you will still find a small hindrance with this change, depending on the version.
Info: Why are Excel macros not always compatible between Mac / PC?
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
