For Next Loop on all Worksheets in Workbook Except the First

[McMan]

I'm trying to figure out how to have a For Next loop run through all worksheets in a workbook besides the first one. Any ideas?

I'd just run the macro starting from the first sheet and have it manipulate all the others after it.

Here's my code for this loop part.

    For Each ws In Worksheets
        ws.Select
 
 
 
'Some format manipulation code here
 
 
 
Next ws

 

[Weaver]

something like

for each ws in worksheets
  with ws
    if .name <>sheet1.name then
      'no need to "select" sheet to do things to it
      'if you need more help with this, let me look at some of the code you're using
    end if
  end with
next ws

You could use

.name <>"summary sheet" then

for example, if you know what the sheet will be called.

HTH

 

[Alpacino]

Try
' if you want to run code except sheet1

For each ws in ThisWorkBook

If ws.name <> "Sheet1" then

Enter code

End if

Next ws

End sub

 

[McMan]

Wow, cool - thanks for the help guys! I really appreciate it!

 

[Phil1981]

Try this thread ....

http://www.mrexcel.com/forum/showthread.php?t=13768