Want copy sheet

  • Thread starter Thread starter Denis Lagoda
  • Start date Start date
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
 
Try using the Set keyword:
Set o=oApp.workbooks.item(1).Worsheets.item("List1")
o.Copy...
 
Back
Top