Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    deleting rows (2002)

    Hello!
    I want to create a macro to delete rows A1198:A65536 . I did Range("A1198:A65536").EntireRow.Delete, I run the macro and nothing happens. What am I missing? Thanks a bunch!

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: deleting rows (2002)

    Is there data in those rows? Once the rows are deleted, the are replaced with blank rows. So if there is no data within the rows, it will appear that nothing happened.

    You code is sound - it does delete the rows. Once the rows are deleted, the are replaced with blank rows.

    If you want nothing to display after row 1197, you can use:

    Range("A1198:A65536").EntireRow.hidden= True

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: deleting rows (2002)

    FANTASTIC! Just what I was looking for! You Rock! Thanks a bunch!

Posting Permissions

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