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.