Help on upgrading to Excel 2003 - development problems!!

[Anna007]

Hi,

I have upgraded from Excel 2002 to 2003 and I have been developing. For some reason, my code is very slow and it was working very fine before in Excel 2002 and very quick!!!
I don't know why?!!!!
It then froze after the code ran. I don't understand why!!!!

Please help asap.. anyone?

Thanx sooo much,
Anna

 

[Anna007]

What is taking about a min (if not longer) is the code for hiding rows of an amortization table. I have about 60 rows and I need to hide all the zero rows of this table. In excel 2002, this would take about a couple of seconds only and now, with Excel 2003, it's taking about a min or longer!!!!!!
Sooooooooooo strange!!

This is the code:
Data = Worksheets("TableConstruction").Range("AmortizationTableHdr")
For iCounter = 0 To 60
If Data.Offset(iCounter + 1, 0).Value = 0 Then
Data.Offset(iCounter + 1, 0).EntireRow.Hidden = True
Else
Data.Offset(iCounter + 1, 0).EntireRow.Hidden = False

End If
Next


I am despartately in need of help!!!


Thanx,
Anna

 

[PHV]

First, replace this:
Data = Worksheets("TableConstruction").Range("AmortizationTableHdr")
By this:
Set Data = Worksheets("TableConstruction").Range("AmortizationTableHdr")

Second, why not simply apply a Filter ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244