PDA

View Full Version : copy current sheet



aoc
04-22-2007, 11:13 AM
hi,

what is macro for copying active sheet to same workbook ?

mdmackillop
04-22-2007, 11:37 AM
Hi AOC,
Try recording a macro, then remove the "Selects" to create the finished code.

aoc
04-22-2007, 11:50 AM
hi,

found it.

ActiveSheet.Copy after:=ActiveSheet