ActiveSheet.Next.Select not working!

  • Thread starter Thread starter Ron McCormick
  • Start date Start date
R

Ron McCormick

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
 
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
 
Thanks, Chip

No it wasn't the last worksheet. I found that a user had
left a stray bit of code on the next sheet that was
meaningless and consequentlly throwing the procedure into
the error routine.

Thanks for your suggestion.

Regards
Ron
 
Back
Top