Macro Excel 2000 do not work in Excel 2003

[gilgil]

I have written a macro in VB for Excel 2000 which creates of subtotal in a
table and then it copies * only the visible cells * on an other sheet. The
macro it works perfectly on Excel 2000 while on Excel 2003 it works in way
not corrected in how much some lines visibles disappear on the final sheet
while the format of the numbers does not come maintained.
Which are the differences between the VB of Excel 2000 and that one of Excel
2003? Where I can find of the explanations?

 

[Tom Ogilvy]

SubTotals
xl2003
xl2002

Perhaps it is related to this flaw:

http://support.microsoft.com/default.aspx?scid=kb;en-us;831824
Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003


Supposedly fixed here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;833855
Excel 2003 hotfix package: February 29, 2004

 

[gilgil]

Thanks Tom,