Does VBA for Excel not allow nested while loops? I don't write macros all that often but whenever I do, I nest a while loop (because I forgot that it didn't work last time), it errors out and I ...

In VBA, both a procedure and ... ActiveCell.Offset(1, 0).Select ‘Move down a row. ... The For Each loop cycles through all the sheets, using the Name property to create a hyperlink for each sheet.