I have a workbook that I want to take all the information in specific cells and put them into a database. I have created a string called myCopy, but when i set it as a range it's giving me an error.
HTML Code: 

here is the attached workbook
Chemical Field Ticket.xlsm

thank you