| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
thank you so much!
"Damon Longworth" wrote: Normally a save will reset the used range. If you had data in one of these cells, you can delete all of the columns to the right of your data and delete all rows below your data. This will reset the used range: x = ActiveSheet.UsedRange.Address To restrict where the user can scroll, have a look at ScrollArea Property in help. -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "acjc7602" wrote in message ... Sometimes when I am working in excel I unintentionally create extra rows that have nothing in them on the sides and at the bottom of my worksheet. I think I do this by scrolling over further than I need or scrolling down further than I want the screen to go. But then I cannot go and delete those extra rows at all. They are just out there without anything in them. Is there a way I can either delete those or only allow someone who uses my worksheet to see the rows and columns I want them to see when they open it up? |
Threaded Mode
