While running the VBA macros in MS Excel, you may receive the notorious “Compile error: Argument not optional.” This warning message can ruin your working experience. So, in this write-up, I’ll discuss the major factors & quick solutions to fix this error in no time with less effort.