http://msmvps.com/blogs/access/archive/2007/08/04/what-i-always-keep-forgetting-about-ismissing.aspxlike using IsMissing when appropriate on the argument list of a subroutine or function. But I keep forgetting that I have to then declare that variable as a variant. Good: Sub SendQuerytoExcel(strQuery As String, Optional strXLSName As Variant, OptionalenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/access/archive/2007/08/04/what-i-always-keep-forgetting-about-ismissing.aspx#1100630Fri, 10 Aug 2007 15:14:26 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1100630Jamie Collins<p>&quot;it sure would be nice if the Microsoft Access team could put this in the VBA compiler&quot;</p> <p>AFAIK the Microsoft Access team do not &#39;own&#39; the VBA compiler.</p> <p>Jamie.</p> <p>--</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1100630" width="1" height="1">