Unhiding part of a range

[petalred]

I'm trying to write VBA that will unhide all the rows in a designated range ("Apples"), except the first and the last.

I'm using this simple code to hide the range:

Please Login or Register  to view this content.

but the first line and last line in the range need to remain hidden at all times and I need a similar script that will unhide the rest of the range for me. Any thoughts on a simple, clean way to do that?

[Conor]

Is there an issue with defining a second named range without the first and last rows of "Apples"?

[Andy Pope]

Please Login or Register  to view this content.

[petalred]

Oh, and to clarify, the number of rows in the range fluctuates wildly. I need a script that will keep the first and last lines hidden when it reveals the range, regardless of how many rows the range contains.

[petalred]

Conor: Sorry, yeah, see my above post (which I must have been posting while you were typing your question).

Andy: Let me give that a shot! Thanks!

[petalred]

Andy, I think you accidentally switched the "False" and the "True," and I caught that before I ran the script and switched them, but the ".Offset" line didn't work. It says "Application-defined or object-defined error." Any thoughts?

[royUK]

Try

Please Login or Register  to view this content.

[Andy Pope]

This works for me

[petalred]

Awesome! That worked! Thanks a lot, Roy!

Andy, I'll check that out. I'm not sure why it's not working on my sheet. Thanks anyway, though.