When I use that formula by itself it works now, however when I add it on to
another macro it doesn't work. Any thoughts?

"Dave Peterson" wrote:

I wouldn't select it first.

TGalin wrote:

3 worksheets. Named A, B, C. Is there a better way to move them then this?

Sub Macro1()
Sheets("A").Select
Sheets("A").Move After:=Sheets(2)
End Sub

--

Dave Peterson