Results 1 to 4 of 4

Thread: ***Resolved***Last row in excel

  1. Mar 19th, 2003, 03:43 AM #1
    beasty1711
    beasty1711 is offline
    Hyperactive Member beasty1711's Avatar
    Join Date
    Mar 01
    Posts
    418

    ***Resolved***Last row in excel

    is there anyway of finding the number of the last row in excel without looping through first?
    Last edited by beasty1711; Mar 19th, 2003 at 04:11 AM.
    "...They even have the internet on computers..." :- Homer Simpson

    "Second Place is First Looser" :- No Fear
    Reply With Quote Reply With Quote
  2. Mar 19th, 2003, 04:01 AM #2
    opus
    opus is offline
    I don't do your homework! opus's Avatar
    Join Date
    Jun 00
    Location
    Good Old Europe
    Posts
    3,562
    Unless you are trying to find the very last row (which is probably empty) thois should work:
    VB Code:
    1. MaxRowNumber = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button

    Wait, I'm too old to hurry!
    Reply With Quote Reply With Quote
  3. Mar 19th, 2003, 04:10 AM #3
    beasty1711
    beasty1711 is offline
    Hyperactive Member beasty1711's Avatar
    Join Date
    Mar 01
    Posts
    418
    perfect thanx
    "...They even have the internet on computers..." :- Homer Simpson

    "Second Place is First Looser" :- No Fear
    Reply With Quote Reply With Quote
  4. Mar 19th, 2003, 04:16 AM #4
    opus
    opus is offline
    I don't do your homework! opus's Avatar
    Join Date
    Jun 00
    Location
    Good Old Europe
    Posts
    3,562
    No problem

    please reedit the starting thread an put an [RESOLVED] in the topic!

    Soory you already did that
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button

    Wait, I'm too old to hurry!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules