Posted to microsoft.public.excel.programming

external usenet poster

Posts: 50

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting a row in a worksheet	Rochelle in Melbourne	Excel Worksheet Functions	1	April 9th 09 11:34 AM
selecting a worksheet	rocket0612	Excel Worksheet Functions	2	March 1st 06 09:47 AM
selecting cell range in other worksheet without switching to worksheet	suzetter[_4_]	Excel Programming	4	June 22nd 05 08:55 PM
Selecting Last Worksheet	Alex	Excel Programming	7	September 26th 04 09:35 PM
Selecting a worksheet with a ComboBox	Todd	Excel Programming	3	July 28th 04 09:37 PM

All times are GMT +1. The time now is 01:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us