When coding in C# with Excel, it doesn't take long before you encounter the dreaded 'optional parameter' issue. If you have ever copied-and-pasted numerous System.Reflection. Missing .Value statements then you've probably wondered a few things. Firstly, what is this and why is it happening? Secondly...