Selecting Next Worksheet
I would like to open a workbook and search the worksheets until the first
blank cell B25 is located and have the worksheet containing the blank cell
B25 be the active worksheet.
This is what I came up with and it is not working because I have a Next with
no For.
Private Sub Workbook_Open()
If B25 = "" Then
Next Worksheet.Select
End If
End Sub
Thanks for any help!
|