Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change macro to paste as last sheet
I have a macro that copies the selected sheet and puts it before all of the
other sheets. How can I change it to put the copy after all of the other sheets (last sheet in the workbook). ActiveSheet.Copy Befo=Worksheets(1) |
#2
|
|||
|
|||
after:=worksheets.count
-- Don Guillett SalesAid Software "Chance224" wrote in message ... I have a macro that copies the selected sheet and puts it before all of the other sheets. How can I change it to put the copy after all of the other sheets (last sheet in the workbook). ActiveSheet.Copy Befo=Worksheets(1) |
#3
|
|||
|
|||
I think Don meant something more like:
ActiveSheet.Copy After:=Worksheets(worksheets.count) or ActiveSheet.Copy After:=Worksheets(sheets.count) Chance224 wrote: I have a macro that copies the selected sheet and puts it before all of the other sheets. How can I change it to put the copy after all of the other sheets (last sheet in the workbook). ActiveSheet.Copy Befo=Worksheets(1) -- Dave Peterson |
#4
|
|||
|
|||
Change that last one:
ActiveSheet.Copy After:=Worksheets(sheets.count) to: ActiveSheet.Copy After:=sheets(sheets.count) Dave Peterson wrote: I think Don meant something more like: ActiveSheet.Copy After:=Worksheets(worksheets.count) or ActiveSheet.Copy After:=Worksheets(sheets.count) Chance224 wrote: I have a macro that copies the selected sheet and puts it before all of the other sheets. How can I change it to put the copy after all of the other sheets (last sheet in the workbook). ActiveSheet.Copy Befo=Worksheets(1) -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if a cell contains certain text, cut and paste to another sheet | Excel Worksheet Functions | |||
how do i change the expense statement template macro | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
vba to sort group copy paste to another sheet | Excel Worksheet Functions |