Hi All

I have a multi worksheet, spreadsheet/workbook (excel).

The application will not know how many worksheets nor how many rows in each worksheet each time it reviews it.

I need to check each row in column 'E' to see if the flag is True or False. If it is true I will need to get information from certain cells from that row, then continue checking the next rows 'E' coluumn.

I need help setting the loop for the 'E' column to start at row 6 and go to the end of the worksheet. Can anyone help; it will be much appreciated.

EXL.Workbooks.Open(sSpreadSheetFileName)
For i = 2 To EXL.Worksheets.Count
            WSheet = EXL.Worksheets.Item(i)
            'need a loop to the end of the worksheet
Next i

Thanks in advance
Tank