Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activesheet error
Hi
I've done something wrong here and I can't work out what it is... Error msg: "Compile Error: With object must be user-defined type, object, or Variant" Sub copylplan() Dim mySheet As String mySheet = ActiveSheet With mySheet .Copy After:=Sheets(Sheets.Count) End With With mySheet .Name = "Extract Plan" End With End Sub -- Thank for your help BeSmart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveSheet.Paste (error) | Excel Worksheet Functions | |||
activesheet paste error | Excel Programming | |||
If ActiveSheet = .. then - I get an error | Excel Programming | |||
ActiveSheet.Paste error | Excel Programming |