Results 1 to 3 of 3

Thread: excel questions

  1. #1
    Lively Member
    Join Date
    Nov 09
    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 04
    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
    Fanatic Member KGComputers's Avatar
    Join Date
    Dec 05
    Location
    www.vbforums.com
    Posts
    550

    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

Posting Permissions

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