Yesterdays question

Posted by Joe Garza on November 01, 2001 6:08 AM

Something happened to my spreadsheet...

The scroll bar on the right of my spreadsheet is for the entire 65,566 rows of my spreadsheet instead of just the area that has input.

Do you know how to correct this?

Posted by Tom Urtis on November 01, 2001 7:47 AM

Yesterdays answer perhaps? 3887.html

Posted by Joe Garza on November 01, 2001 8:03 AM

Re: Yesterdays answer perhaps? 3887.html

My bad...I didn't know that was an answer. I didn't know the questions were numbered.

Ok...so I tried the macro and it didn't work. I am not good with macros but I typed it in exactly as you have it.

Posted by Tom Urtis on November 01, 2001 8:32 AM

A couple possibilities

Joe,

Here are a couple ideas:

(1) What should really work is if you run a macro with the following line of code as the last line:

ActiveSheet.UsedRange

Or a macro like

Sub Reset()
ActiveSheet.UsedRange
End Sub

(2) Is there maybe a cell way down there that really does contain data or formatting? Sometimes by mistake that can happen so take a close look. If you are absolutely certain that no such cell should exist, then Edit > Clear > All for the rows below your last used one, and try running the above macro again.

If you still have trouble then re-post and someone else may know of something to try.

HTH

Tom Urtis