Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding next blank row (xl2000)

    Whats the routine for finding the next blank in a table?

    Something like
    Range("MyRange").Select
    UsedRange.End(xlUp).Offset(1,0).select

    Cant remember it and the Search is down. Hope we get it back

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

    Re: Finding next blank row (xl2000)

    Can you be a tad more specific? Do you want to find a blank cell in a specific column, or the first blank row within a table, or the highest unused row in a workbook (below all "used" rows), or ...?

Posting Permissions

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