Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Broken macro in Excel 2003
wow. If a procedure is 4 pages then it strikes me that its way too big. IMHO
Try to break it down ito pieces if you can. Have you tried stepping through it? To do that, put a breakpoint in somehwre near the start (F9) and then step (F8) This might allow you to see what its doingto that last line. "kmbarz" wrote: I've inherited an Excel spreadsheet that has a complex data handling macro. If it's run on Excel 2000/Windows 2000 it runs just fine. If I run it on Excel 2003/Windows XP Pro, the data in the bottom line of each table it creates corrupts. I've isolated the issue down to one subroutine, but even that printed out is four pages, and I'm new to the Excel model to boot. So, is there any resource out there for what is likely to break in VBA in going from 2000 to 2003? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Broken? | Excel Worksheet Functions | |||
I believe the rate function is broken in Excel 2003.... I can't verify this with other sources though | Excel Discussion (Misc queries) | |||
Macro broken with workbook name change | Excel Discussion (Misc queries) | |||
upgrade to excel 2003 update broken links error | Links and Linking in Excel | |||
Has my macro broken Excel? | Excel Programming |