Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet.Copy Expected Function or Variable Error
This seems fairly straight forward to me, yet it produces a compile error:
"Expected Function or variable." Dim oOldSheet As Worksheet Dim oNewSheet As Worksheet Set oOldSheet = ActiveSheet Set oNewSheet = oOldSheet.Copy(oOldSheet) Any suggestions? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet.Copy Expected Function or Variable Error
I'd use:
Dim oOldSheet As Worksheet Dim oNewSheet As Worksheet Set oOldSheet = ActiveSheet oOldSheet.Copy after:=oOldSheet Set oNewSheet = ActiveSheet Lazzaroni wrote: This seems fairly straight forward to me, yet it produces a compile error: "Expected Function or variable." Dim oOldSheet As Worksheet Dim oNewSheet As Worksheet Set oOldSheet = ActiveSheet Set oNewSheet = oOldSheet.Copy(oOldSheet) Any suggestions? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Variable Range to New Worksheet | Excel Programming | |||
Compile Error: Expected Variable or Procedure, Not Project | Excel Programming | |||
compile error: Expected: = ...Why? | Excel Programming | |||
how do i use the function to copy and paste a determined variable. | Excel Worksheet Functions | |||
compile error: expected variable or function | Excel Discussion (Misc queries) |