Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving sheets
Hi I am copying a worksheet from a book and what I am looking to have this
automatically to the end of the workbook. How would I do this? I have used the manual macro builder and it gives a code like Sheets("Sheet4").Move After:=Sheets(5) But my workbook will have continous added sheets Thanks in advance Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving sheets
Hi Greg
you could try something like this dim i as long i = sheets.count sheets("sheet4").move after:=Sheets(i) Cheers JulieD "Greg" wrote in message ... Hi I am copying a worksheet from a book and what I am looking to have this automatically to the end of the workbook. How would I do this? I have used the manual macro builder and it gives a code like Sheets("Sheet4").Move After:=Sheets(5) But my workbook will have continous added sheets Thanks in advance Greg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving sheets
Thanks Julie
Once I worked out how to put into my code. It works perfect Greg |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving sheets
thanks for the feedback
"Greg" wrote in message ... Thanks Julie Once I worked out how to put into my code. It works perfect Greg |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving sheets
I think it did Julie it has not shown up
Thanks again Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
Moving Between Sheets | Excel Discussion (Misc queries) | |||
Moving through sheets | Excel Discussion (Misc queries) | |||
Moving through sheets | Excel Programming | |||
moving between sheets | Excel Programming |