Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Active Worksheet
Hi all, I just need to copy the active worksheet and paste in the same workbook then activate that new sheet. I know how to do this manually but i need the code to copy the sheet without referencing the actual name of the sheet (because the name of the activesheet willl obviously depend on which sheet i'm on). I tried recording the macro but this obviously returns the sheet name as part of the code - which is not quite what i want for subsequent sheets. Hope this is clear and if anyone wcould rustle up an answer before 3am tomorrow morning (it's 10.30here) i would really appreciate it. thanks a bundle, Chris -- chris100 ------------------------------------------------------------------------ chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166 View this thread: http://www.excelforum.com/showthread...hreadid=478055 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Active Worksheet
Just figured out how to do this by piecing together a couple of other lines from different places: Sub Macro1() ActiveSheet.Select ActiveSheet.Copy befo=Sheets(1) Application.Run "RefireBLP" End Sub -- chris100 ------------------------------------------------------------------------ chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166 View this thread: http://www.excelforum.com/showthread...hreadid=478055 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Value of Active cell and 25 rows above to a diff worksheet | Excel Discussion (Misc queries) | |||
Macro to copy active worksheet to new workbook | Excel Discussion (Misc queries) | |||
copy active cell value,find the pasted value in different worksheet | Excel Worksheet Functions | |||
Copy data from 3rd worksheets and pasting to active worksheet | Excel Programming | |||
Copy worksheet from Active workbook into all other open workbooks | Excel Programming |