Results 1 to 3 of 3

Thread: excel questions

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Nov 2009
    Posts
    76

    excel questions

    Is there a way to determine how many rows in the worksheet have data filled? I tried looping through the 1st column of each row until I see a cell that is empty, but when it gets to an empty cell it always gives me an excel range error.

    Also what is the command to fully close an excel workbook. When I use the close command it closes the worksheet, but still leaves excel running.

  2. #2
    Fanatic Member x-ice's Avatar
    Join Date
    Mar 2004
    Location
    UK
    Posts
    671

    Re: excel questions

    Quote Originally Posted by giants00 View Post
    Is there a way to determine how many rows in the worksheet have data filled? I tried looping through the 1st column of each row until I see a cell that is empty, but when it gets to an empty cell it always gives me an excel range error.

    Also what is the command to fully close an excel workbook. When I use the close command it closes the worksheet, but still leaves excel running.
    With regards to closing Excel try this.

    http://www.dotnetperls.com/kill

  3. #3
    Frenzied Member KGComputers's Avatar
    Join Date
    Dec 2005
    Location
    Cebu, PH
    Posts
    2,020

    Re: excel questions

    Hi!
    [but when it gets to an empty cell it always gives me an excel range error.]

    Have you tried type casting that range or cell value which is object to a string type?

    Greg
    CodeBank: VB.NET & C#.NET | ASP.NET
    Programming: C# | VB.NET
    Blogs: Personal | Programming
    Projects: GitHub | jsFiddle
    ___________________________________________________________________________________

    Rating someone's post is a way of saying Thanks...

Posting Permissions

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



Click Here to Expand Forum to Full Width