hi,
what is macro for copying active sheet to same workbook ?
hi,
what is macro for copying active sheet to same workbook ?
Hi AOC,
Try recording a macro, then remove the "Selects" to create the finished code.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
hi,
found it.
ActiveSheet.Copy after:=ActiveSheet