Unhiding Rows Problem

[Dan in Lowell]

Hello,

I am having an issue with Hiding and Unhiding rows in my woorkbook. I have hidded a number of rows in my work book and when I Unhide them by selecting the entire worksheet, they unhide OK but my scrolling is disabled. The address indicator shows that my cursor is movimng down the rows but the screen never changes to show the row where the cursor is?

 

[GlennUK]

Make sure you don't have any frozen panes - Windows/Unfreeze Panes is the menu command if that's the case.

 

[Dan in Lowell]

Thank you Glenn,

Actually that was the first thing i checked and i do not have frozen panes. Odd thing is that I can scroll side to side just not up and down

 

[GlennUK]

Hmmm, interesting. How about going into the VBE and looking at the sheet properties, specifically ScrollArea.

 

[Dan in Lowell]

Good idea. I will check that out.

Thanks