Delete Method's return value in Excel VBA <p>According to Microsoft Developer Network, both <code>Range.Delete</code> and <code>Worksheet.Delete</code> method will return a value. However, by using the <code>MsgBox</code> function I can only view the return value for the <code>Worksheet.Delete</code> method but have no luck with the <code>Range.Delete</code> method. The code I used is <code>MsgBox Worksheets("Sheet1").Delete</code></p> <p>Here are the two articles from MSDN for your information: <a href="https://msdn.microsoft.com/en-us/library/office/ff837404.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/office/ff837404.aspx</a> <a href="https://msdn.microsoft.com/en-us/library/office/ff834641.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/office/ff834641.aspx</a></p>