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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Copy entire row from another sheet onto first sheet if a unique text matches 1
Combine Lists 1
Save workbook without shapes 0
Need Help with a VBA subroutine 0
Combining two sheets of data into one and sorting by value - using macros 5
Copy addition formula of non-consecutive horizontal cells 2
Making a Sheet copy 3

Top