Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Please refer to the attach. I have tried by watching youtube but doesn't works well therefore the copy of range of data to another worksheet is not in there.
Secondly just to ask can I just copy the whole excel and change the worksheet name and the code accordingly and still works? I tried to do that but always get an error when launching the userform. Debug shows MMS_SPARE_IN.show
Last edited by ericwangjt; 12-27-2017 at 03:11 AM.
In answer to your second question, I'd have to look at the code. If the code references specific worksheet names, then the code will break if these sheet names are changed. On the other hand, tables and named dynamic ranges know where they are even when the sheet names on which they are are changed.
Hi, in the code did reference to specific worksheet names. However I did a run through of the code there is no left out/overlook so I not sure where went wrong and do you think is possible because the debug bring me to the MMS_SPARES_IN. Does that mean it could be code problem in the MMS SPARES IN form?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks