Posted to microsoft.public.excel.programming

[email protected] cfatz1@gmail.com is offline

external usenet poster

Posts: 36

Go To Next Worksheet in Loop

Hi-

I have the following code. When it runs I get a "Subscript out of
range" error. Can anyone clean this up for me and get me to the next
sheet in the workbook? Thanks in advance for your help!

For x = ActiveSheet.Index + 1 To Worksheets(Worksheets.Count).Index
Range("B2").Select
If ActiveCell.Value = "Distributor:" Then
FUNCTION1
End If
Sheets(x).Select
Next x

Thanks,
Chris

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
Worksheet loop won't loop	L. Howard Kittle	Excel Programming	4	March 17th 06 12:56 AM
Do loop to add a new worksheet	Alex	Excel Programming	2	August 19th 04 11:35 PM
how do you loop through each worksheet?	dundonald	Excel Programming	16	January 11th 04 02:20 PM
worksheet loop	scott[_8_]	Excel Programming	8	November 17th 03 09:49 PM
How? Macro to copy range to new worksheet, name new worksheet, loop	Repoman	Excel Programming	9	October 9th 03 01:45 PM

All times are GMT +1. The time now is 05:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us