So refreshing to have you ask a question for a change rather than answering
them! <big g> An opportunity to give back...



I don't know why you're getting that particular error - I would expect an
error 91 - Object variable or With block  variable not set - but I notice
you're not selecting the first worksheet  initially, so I would think it's
very possible it's trying to select PAST the last worksheet.



So, does putting:

Application.ActiveWorkbook.Worksheets(1).Select

just before the For/Next loop help?