Want copy sheet

D

Denis Lagoda

To make a sheet copy in the same workbook I do this (from Foxpro):

o=oApp.workbooks.item(1).Worsheets.item("List1")
o.copy (0)

And get an error that property is not supported
 
B

Bob Umlas

Try using the Set keyword:
Set o=oApp.workbooks.item(1).Worsheets.item("List1")
o.Copy...
 
Top