Hidden Rows with VBA - Cannot Unhide

**prairied0gg** · 04-30-2010, 12:08 AM

I am very happy that I found this forum. I have been beating my head against my desk for way too long!

Here's my problem:

I have a series of toggle buttons that hide and unhide rows based on the number of days between 2 dates. If the number of days are such that all rows end up being hidden, I cannot get them back! I can get one back, but that is all.

I can't express how grateful I would be for someone out there to help me...

**shg** · 04-30-2010, 12:12 AM

Welcome to the forum.

Change the button properties to not move or size with cells.

**prairied0gg** · 04-30-2010, 12:18 AM

It seems as though I should have waited a couple of minutes before posting!

I was attempting to hide/unhide cells in the following range:
Range(Range("A5"), Range("A65336").End(xlUp))

If I change that to read:
Range("A5:A7000")

it works fine. I don't yet know why, but at least it's working.

shg, thank-you for the welcome and thank-you for the reply!

**prairied0gg** · 04-30-2010, 12:20 AM

Sorry! I just realized that I posted in the "Access" section of the forums. I should have been in the "Excel" section.
My bad.

**royUK** · 04-30-2010, 01:17 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here