<div>
Quazi,<br />
Rather then doing the loop, You can do what you are looking for in simple two commands which is this...<br />
This will even move to the next step even when the worksheet is not there...<br />
Saurabh...<br />
<br />

<pre><code id="code-289557">On Error Resume Next
Sheets(&quot;France&quot;).move before:=Sheets(&quot;Germany&quot;)
</code></pre>
</div>


Quazi,
Rather then doing the loop, You can do what you are looking for in simple two commands which is this...
This will even move to the next step even when the worksheet is not there...
Saurabh...



On Error Resume Next
Sheets("France").move before:=Sheets("Germany")


<div>
Thanks Saurabh. &nbsp;As always, your help is awesome. &nbsp;Could you give me the full code? &nbsp;In many ways, I'm still a newbie. &nbsp;Thanks.
</div>


Thanks Saurabh.  As always, your help is awesome.  Could you give me the full code?  In many ways, I'm still a newbie.  Thanks.

<div>
Perfect solution. &nbsp;Thanks!
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts-<br />
<br />
I want to move a sheet if it exists. &nbsp;I came up with the code below and am curious why it won't work. &nbsp;Any help would be appreciated.<br />

<pre><code id="code-289552">Dim ws As Worksheet
Dim i As Long 
    For Each ws In ActiveWorkbook.Worksheets
        If ws.Name = &quot;France&quot; Then
            Sheets(&quot;France&quot;).Move Before:=Sheets(&quot;Germany&quot;)
        End If
    Next ws
</code></pre>
</div>
</div>


Hi Experts-

I want to move a sheet if it exists.  I came up with the code below and am curious why it won't work.  Any help would be appreciated.

Move Sheet If It Exists

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.