Sub or Function not defined Excel VBA (w/ Command Button)

Copper Contributor

Hello! I am working on coding a macro that transfers three columns of data from one workbook to another.  When setting up and running the program, I keep getting a Compile Error: Sub or Function not defined.  I have referencing turned on and have tried multiple methods of troubleshooting.  Any help with fixing this problem would be greatly appreciated.  Thanks in advance!

strugglingChemE_0-1656092548260.png

It will highlight the top line and usually the word 'Worksheets' as well.

*If I need to provide any additional information please let me know!

2 Replies

@strugglingChemE 

You can try 'Worksheets' instead of 'Workseets'.

Great point thank you! I am still receiving an error from the first part of the code.