Loop through a subset of worksheets will not work

Greetings,

I'm trying to insert two rows in a subset of worksheets in a workbook by defining a range in a worksheet and loop through the worksheets in that range, but the code will only run on the active worksheet.

Please Login or Register  to view this content.

Any thoughts on how I could get this loop to work?

Thank you very much,

Hi,

You need to qualify code like

Please Login or Register  to view this content.

with the sheet name.i.e.

Please Login or Register  to view this content.

Although it's not clear to me why you use Dim sheet_name as range. I was expecting to see "As String"