VBA command to move contents from 1 sheet to another

[Chandana_Gadugu]

Hi,

Below is the command which is used in my previous version of excel i.e excel 2003 to move the contents of 1 sheet to another

Worksheets(MySName).Move After:=ThisWorkbook.Sheets(1)

But the same command is not working in excel 2007 and excel 2010.

Can anybody help me regarding the same.

Thanks in Advance,
Chandana.G

 

[repairman615]

Hello,

Here is basically what I get from the recorder:

Sheets("Sheet1").Move After:=Sheets(3)

 

[paddydive]

Hi Chandana,

Try below code , hope it work for you.

Sheets("MySName").move After:=Sheets("sheet3")

This will work if you want to move sheet in same workbook.

For more details please check

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

 

[repairman615]

The original code seems to work for me.

Double check that the variable MySName is correct and that there is a sheet named the same.


<font face=Courier New><SPAN style="color:#00007F">Dim</SPAN> mysname <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">String</SPAN><br><br>mysname = "Sheet1"<br><br>Worksheets(mysname).Move After:=ThisWorkbook.Sheets(1)</FONT>