Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unable to Insert Row(s) (XL97; SR2)

    Has anyone encountered a problem with inserting a row or the fact that you can not insert one. XL is giving the impression that there is cell contents on the last row. Well there is not. If you take a blank worksheet and put a number say in cell F24 and delete the contents, go to cell A1. Press END and HOME ; you jump from cell A1 to F24 although there is nothing in cell F24.

    Any ideas as to what is happening?

    Thanks,
    John

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Unable to Insert Row(s) (XL97; SR2)

    When you delete a value from the last cell in a worksheet, Excel does not do what it should and reset the used range. Normally saving the file gets around this problem. Or try th efollowing routine and see if it will work for you :<pre> Sub ResetUsedRanges()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Sheets
    ws.Activate
    ActiveSheet.UsedRange
    Next
    End Sub</pre>

    Of course that will not deal with situstions where blank spaces may somehow get entered into a cell.

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •