Results 1 to 2 of 2

Thread: Used range (XP)

  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Used range (XP)

    Is there an easy way to reduce the size of the Used Range of a worksheet. For example if you clear a number of rows at the end of a sheet, the used Range still includes those rows.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Used range (XP)

    Excel 2002 (XP) is better at this than previous versions - usually, the UsedRange is reset when you save the workbook.
    Executing any VBA statement that refers to UsedRange is supposed to reset the UsedRange. You could type

    ? ActiveSheet.UsedRange.Address

    in the Immediate window and press Enter.

    Also see the threads starting at <post#=50564>post 50564</post#>, <post#=133048>post 133048</post#> and <post#=190787>post 190787</post#>.

Posting Permissions

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