Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Thanked 0 Times in 0 Posts

    Deleting Empty Rows (Excel 2000 VBA)

    Wow--the lounge sure has changed since I was here last--great job! I know this may sound like a very lame question, but I've allowed my VBA skills to atrophy.

    The basic challenge is simple. I need to march down a single column of cells and examine their contents. If the cell is empty, I need to delete the row; othewise I need to do stuff. Consecutive rows may be empty.

    I can easily go from row to row. My problem is when I delete a row, I can't manage to select the new, active oCell to examine the new contents (if any). Very frustrating...

    I'd include my code if that would be helpful, but it sounds like it should be something one of you lizards should be able to answer in your sleep.

    Thanks so much.

    Jimmy May--Aspiring Geek

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: Deleting Empty Rows (Excel 2000 VBA)

    See my answer to the same question in the Excel forum.
    Legare Coleman

Posting Permissions

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