View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fleone Fleone is offline
external usenet poster
 
Posts: 50
Default 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!