Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Determine the last row used in an excel

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,34918
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Determine the last row used in an excel
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
Determine the last row used in an excel - 5/26/2006 5:03:47 PM   
  mpang

 

Posts: 3
Score: 0
Joined: 5/24/2006
Status: offline 		Original message moved by Country73
Reason : Wrong forum
 Hi,

   I have an excel file as below:


    ID                    Name          Position    Job Description
    1230                Ann             CEO
    4560                Kate            Programmer

    7890                Travis          System Analyst
    0000                Dennis         Tech


I am wondering what is the best (most efficient) way to determine the last row used in the worksheet. Thanks in advance
 
 
Post #: 1
 
RE: Determine the last row used in an excel - 5/30/2006 9:49:47 AM   
  BBistheKing

 

Posts: 107
Score: 0
Joined: 6/21/2005
Status: offline 		Loop through the rows until you find a blank cell. I don't know if this is the most efficient method. Look here for some inspiration...

http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun05/hey0629.mspx

_____________________________

"Live simply, that others may simply live." - Mahatma Gandhi

(in reply to mpang)
 
 
Post #: 2
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Determine the last row used in an excel Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI