Problems hiding cells

[Hatye]

Hi,

I have posted this question in some other forums, but no one knows whats wrong (even though many have replied). Hopefully someone here knows whats wrong!
I use the following code for hiding some rows:

Please Login or Register  to view this content.

Then I receive this error:
2h6d0zt.jpg
The error says: "Can not set Hidden-property to the range class" (freely translated).

FTR: I'm using Office 2010.

Can anyone help me with this?

[stnkynts]

I removed the With ActiveSheet.Buttons section and it worked fine for me. You issue has something to do with that.

Please Login or Register  to view this content.

[Yraen]

It all runs fine for me. It makes the button small and hides rows 59 thru 499. it doesn't seem to hide all of the other rows though. Do you have anything going on in the worksheet module?

[Hatye]

I removed the With ActiveSheet.Buttons section and it worked fine for me. You issue has something to do with that.

Please Login or Register  to view this content.

Hi stnkynts,

Thank you for the reply

It doesn't seem like that's the problem, cause the macro stops at the code

Please Login or Register  to view this content.

as shown over.

[stnkynts]

Is the file saved as a 2003 workbook. 2003 doesn't have 1048576 rows so it would fail on that. Using Rows.Count would be more optimal and would correct this issue going forwards.

Bad:

Please Login or Register  to view this content.

Good:

Please Login or Register  to view this content.

[Hatye]

I'm using Office 2010, but found out what was wrong, so this has been solved