Problem with VBA code written in 2007 and run in 2010

My office is in the middle of upgrading from office 2007 to 2010. I have not noticed any problems with any of my files except for this one. From what I've researched and talked with people it seems that my code is not complex enough (nor am I very advanced) to have my code effected by the upgrade from VBA6 to VBA7. I am still on 2007, but have access to a virtual version of 2010 .

I have this report that calculates amount of spend for each project that I (and others) run often from a sample of data we pull out of a larger database. Other code sets up the report and pulls out the data for each project to create a sheet for each project with a summary of spend and total spend. Everything works correctly in 2010 except for the calculation part (the very last part) of this macro where the totals (based on the conditions) are placed in B4, B5 and B6. When I run it in 2010, B4, B5 and B6 all have the equation that B6 should have. It seems like the equations are copied over in the cells because when i run it without B6, the equation in B5 is in the cells B4, B5, B6. I run this macro again for the cells C4, C5, C6 and the same thing happens except the equation for C6 is in C4, C5 and C6. I have tried using relative references and that made no difference.

Please Login or Register  to view this content.

I'd really appreciate any help!

Hello kmichae,

Welcome to the Forum!

The only obvious problem I see is you don't have a line label in your code for "SU". If POcnt is zero this will error.

Please Login or Register  to view this content.