Although the formula works by itself when I add it on to another macro
nothing happens. Any thoughts?

"AltaEgo" wrote:

You don't need to select the sheet. It will be active after the move.

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


Other sheet copy/move code:

http://support.microsoft.com/kb/288402

--
Steve

"TGalin" wrote in message
...
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