Excel for Mac Runtime 1004 error

Question

Hello All, I'm sorry, but I am at wits end.  I've looked through this forum and elsewhere for a fix to a "runtime error 1004".  Here is just a bit more information.

What I am trying to accomplish is: 

• user opens .xlsm workbook with two worksheets, one of which contains my macro
• data is entered to the New Assignment Sheet (sheet 1)
• once the data is entered, the update button is pushed and data is transferred to sheet 3
• sheet 3 will be a running log of the data entered on sheet 1
• Excel (for Mac) is left open and ready for new data to be entered on sheet 1

The coding for my issue is included above.  This all appears to work the first time I use the macro, but on all successive attempts I get the error code.  

Any suggestions from the group would be greatly appreciated.  I would like to get this issue solved as quickly as possible. 

I appreciate any guidance you can provide. 

Preston 

**Post moved by the moderator to the appropriate forum category.**

Answer 1

Thank you! It's so much easier to figure things out when I can watch and see what's going on.

The trouble is how you are using XL down. This link has a great explanation of why it's not working for you and how to fix it.

http://stackoverflow.com/questions/9404654/excel-vba-xldown

BTW - If you want to make your options so that it's either Yes or No, or only one of a group of options, use radio buttons instead of check boxes. Then enclose groups of radio buttons with Group boxes.

Answer 2

Here ya go.  Any assistance would be appreciated.

https://www.dropbox.com/s/hmu8g15fkt0a8zp/Assignment%20Sheet%202017.xlsm?dl=0

Happy New Year!!

Preston

Answer 3

The idea behind this community is that we all share the workload. You should remove any personal information and confidential information, then share the link to the download so that anyone interested in helping can pitch in.

Answer 4

I will share it on Dropbox.  Can you send me your email address or contact information?  Thank you!

Answer 5

Me, being on the lazy side and strapped for time, would like to tackle this without having to manually read and type your code. If you could share your workbook on DropBox or OneDrive, or at least paste the text of the code in a reply so all I have to do is copy and paste, that would be better. Sharing would be best because I can't see what's on the worksheets, and that could affect what's happening in your code.