M
mohsen
Hello, Here is a question:
I have a very complicated worksheet, with about twenty or so sheets.
It's really hard, unless you are familiar with the logic to follow the
instructions on how to fill these sheets out. So, I decided to create a
wizard, where the end user is walked through the various sheets. I wrote
the code in a form housing a spreadsheet control, each time the user
clicks on "Next" or "Back" the spreadsheet control is updated with the
next or previous worksheet. Here is the code I am using to get the data
from excel worksheet and display it in the spreadsheet control:
Worksheets(myworksheet).Range("A1", "M200").Copy
Spreadsheet1.ActiveSheet.Range("A1").Paste
It works beautifully.... But when I try to do the reverse, I get error
438, the object does not support this property.
Spreadsheet1.ActiveSheet.Range("A1", "M200").Copy
Worksheets(myworksheet).Range("A1").Paste
Anyone with any ideas, please....
Mohsen
I have a very complicated worksheet, with about twenty or so sheets.
It's really hard, unless you are familiar with the logic to follow the
instructions on how to fill these sheets out. So, I decided to create a
wizard, where the end user is walked through the various sheets. I wrote
the code in a form housing a spreadsheet control, each time the user
clicks on "Next" or "Back" the spreadsheet control is updated with the
next or previous worksheet. Here is the code I am using to get the data
from excel worksheet and display it in the spreadsheet control:
Worksheets(myworksheet).Range("A1", "M200").Copy
Spreadsheet1.ActiveSheet.Range("A1").Paste
It works beautifully.... But when I try to do the reverse, I get error
438, the object does not support this property.
Spreadsheet1.ActiveSheet.Range("A1", "M200").Copy
Worksheets(myworksheet).Range("A1").Paste
Anyone with any ideas, please....
Mohsen