Can't copy ActiveSheet to clipboard

  • Thread starter Peter Chatterton
  • Start date
P

Peter Chatterton

Shouldn't this code create a new worksheet from the active one?

It does create a new sheet,
but just copies the current clipboard to it.

ActiveSheet.Select
ActiveWorkbook.Sheets.Add After:=Worksheets(1)
ActiveWorkbook.Worksheets(2).Paste

Thanks,
Peter
 
N

Norman Jones

Hi Peter,

To add a copy of the active sheet, try:

Sub Tester()
ActiveSheet.Copy After:=Worksheets(1)
End Sub
 
P

Peter Chatterton

Thanks a lot Norman.

So why doesn't ActiveSheet.Select put anything in the clipboard?

Peter.
 
N

Norman Jones

Hi Peter,
So why doesn't ActiveSheet.Select put anything in the clipboard?
Click to expand...

This command selects the activesheet (which is already selected); it
includes no copy instruction.
 
Top