Dealing with a worksheet name with spaces
<p>I'm able to set a worksheet name without spaces and manipulate it with out issue. However, everything I've tried with spaces doesn't work. </p>

<pre><code>Dim myBook As Workbook
Dim myWorksheet As Worksheet
Set myBook = ActiveWorkbook
Set myWorksheet = myBook.Sheets("my worksheet name")
</code></pre>

<p>I've tried setting single quotes around it alone. </p>