-
Aug 22nd, 2012, 09:45 PM
#1
Thread Starter
Lively Member
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.
-
Aug 23rd, 2012, 05:55 AM
#2
Fanatic Member
Re: excel questions
Originally Posted by giants00
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
-
Aug 24th, 2012, 02:00 AM
#3
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|