If you're unhiding rows a row at a time, make sure you turn off pagebreak
indicators before you start. And make sure you're not in pagebreak view, too:

ActiveSheet.DisplayPageBreaks = False
ActiveWindow.View = xlNormalView

would be near the top of your code.

rs wrote:

Hello everyone.

I am encountering a very strange behaviour. Last week it was taking
almost 2 sec to unhide/show 10,000 rows. But, today it is taking almost
3mins to show the same rows.I opened a last week version of the
workbook and it took 2 secs to show the rows.

Hidding rows works fine.

Does that mean the workbook got corrupted? How can fix that.

Any help is appreciated.

--

Dave Peterson