maybe something like this:

do while not eof

' your code

loop
--


Gary


"RSteph" wrote in message
...
Is there any kind of End of Sheet indicator (like an EOF value) With VBA with
Excel? I've got a .csv file that lists a number of purchases. There are
certain rows that I want to remove from the file, some sub total rows and
what not.

The easiest way I can think of to handle that is to cycle through column 'C'
(where the order number is located) and if that column is blank, or has an *
in it, then I know I can delete it. The size of the file will vary depending
on the date range that was used in creating the .csv. So I was wondering if
there was an easy way to figure out where the last row with any data in it
is, or if I need to just use a row number that I know will never be reached
(i.e. 2000)?

Thank you in advance for any help offered.