ws
is the worksheet where you write. Note that I did not provide the code to open/load the workbook and get the worksheet. It was missing also in your code. You need to add your code to load the workbook. It's obvious after all
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs