Ron,

Are you sure you are not trying to get the next worksheet of the
last worksheet in the workbook?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ron McCormick" wrote in message
...
I have a procedure that goes through certain worksheets in
a number of workbooks and extracts data and then moves (or
is supposed to move) via a loop on to the next sheet using
the following code - 'ActiveSheet.Next.Select', the next
line of code being 'GoTo Resumeline'

The procedure works fine until it come to one particular
sheet at which point it jumps out of the loop to an error
handling routine, which keeps the procedure running on the
same sheet without going on to the next sheet, and thus
never getting out of the loop.

Anyone got any idea why this could be happening?

TIA
Ron