Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: How do i move down 1 cell?

    i want to go to the last row of data : Selection.End(xlDown).Select
    then move down 1 more row, if the cell has no data then delete down 500 rows.


    How can i accomplish the rest of the code?


    Thnks

    M~!

  2. #2
    Join Date
    Oct 2003
    Posts
    311
    Range("A1").Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Range("A1").Select

    Range(Selection, Selection.End(xlDown)).Select
    Selection.EntireRow.Delete

Posting Permissions

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