Excel VBA: Loop across sheets and select same row
This video will show you an alternative, in selecting the same row in each worksheet using a VBA macro. As most Excel users know, if we group all worksheets, we are able to dynamically select the same row.
However, if we need the base VBA code, then we need a macro like this in Visual Basic for Applications.