worksheets.add breaks Do loop in Excel 2010?

Hi all,

I have some old code that was written for Excel 2000, but I've since found a similar subroutine on MSDN which exhibits the same behaviour.

Please Login or Register  to view this content.

This code encapsulates the problem (the whole VBA is much longer).
Column text headings are in A1 to n1 (i.e. dynamic range). Here a worksheet is added for each column header with the value of the header becoming the worksheet name.

The issue is that the Sub routine exits (without error) when the first worksheets.add statement is reached, so the loop is only entered once.

I've never seen this before.
If I omit the worksheets.add statement, the loop happily iterates through the headers, selecting each of them.

any ideas?
cheers,
Kieran

Thanks for your input David, but this causes exactly the same issue.

It exits without error at

Please Login or Register  to view this content.

---------- Post added at 12:58 PM ---------- Previous post was at 12:53 PM ----------

Geez.. I dunno. Scratching my head, because the logic (in both) looked good to me, I thought 'let's restart'.
So I just restarted Excel + my computer, and now both work (including the one I posted my query about).

Sorry for the bother, and thanks again for your time David.

Excel must have been having a brain hemorrhage.