If condition is met Then End If Else results in Else without If error

Hello all,
I have an issue that I am sure is an easy solve. But I am a little stumped. The code below is supposed to format the selected range, however, since I am using End(xlDown) if there are no values in that range it will select the entire sheet. Since a give range will never be more than a few hundred, so if it selects more than 1000 rows, I want it to skip the formatting. My guess is that I have the syntax wrong for ending the If when the >1000 condition is met. This is part of the code that is telling me "Else without If":

Please Login or Register  to view this content.

Thanks

What is RowTotSub(1)? Seems to be wrong

Please Login or Register  to view this content.

Norrie,
If I remove the first end if then it just goes to the else and I am back to the original problem which is that it selects the entire sheet. I need a way to exit or end the if if the condition is met.
AB33,
RowTotSub(1 To 4) is a Variant.

If it true, the code is not doing anything, hence I added a line with a comment.

HaHoBe,
That worked! Thanks!

Norie,
I omitted the selection part because that worked and would have required posting far more code to make the selection process understandable. It was the formatting part I was having trouble with.