I have a Molecular Mixing Model spreadsheet that uses VB macros in Excel 2003. It works fine on several workstations at the lab, but it does not work on my laptop. I am trying to resolve this.
It fails on a paste special saying that the paste area is not the same size as the copy area. However, I suspect that there is a compatibility issue since the exact same code works on other machines.
I have verified that I have the Solver add-in, but am not sure how to check if there are others I need.
I have tried to use Tools > References in VBA debugger, but it is grayed out. I have tried highlighting the work sheet, the modules, etc. with no success.
I have enabled macros and set security to Low (temporarily) and trusted VB scripts.
I have tried to update Excel using Microsoft Update and the update has failed. I am not sure. I do have an older version of Excel 2003 than my co-worker's workstation:
My Excel: 11.6560.6568 SP2
Working Excel: 11.8220.8202 SP3
I am working to resolve the update problem as well, but if someone can help me determine what else to check, I would really appreciate it.
Bookmarks