Help! I'm on my first real assignment without any resources in work. I need 2 things:

1. A way to check for 2 empty rows in MSExcel
'I'm trying this (It doesn't work!)
For I = 4 To 100
If XL.Range("A" & I : "J" & I) = "" Then
MsgBox "end found"
Exit Sub
End if
Next

2. A way to go through the worksheets collection without physically typing out all 17+ tab names so that I can do some actions to each one, then move to the next sheet and do some more actions.

Thanks in advance, any help is appreciated, I'm "temp to perm" on this job. If I can't do this I may be not have a chance at the "perm" end of this job. Please Help.