Getting problems while accessing data from Excel Sheet

[Ankur]

See if this helps... note the position of Exit For

Code:

Main Excel Sheet(6 rows)
For Loop for Main Excel Sheet
If Header is Yes in Main sheet
Sub Excel sheet(1 row)
For Loop for Sub Excel Sheet
Next
Exit For
End If
Next

Also check out the article on excel automation model for further reference.