Note: Make sure to delete the old module. Step 4: Navigate to the File menu and click on Save Global. Step 3: Paste the VBA code that you want to use. Step 2: Select the Insert tab of the VBA Editor and click on the Module option or click on Tools > Macro then name the macro and press Enter Step 1: Select the developer tab on the Excel menu and click on the Visual Basic option or Click on Alt + F11 simultaneously. However, I strongly advise you to check your macro very well to be certain that the error is not coming from the code itself before attempting any fix. Consequently, you might have to try one or a combination of the methods below to fix the problem. The VBA 400 error message does not give any indication on the origin of the error. Note: VBA 400 error messages can arise in any of the following Microsoft Windows operating systems: Windows 10, Windows 8, Windows 7, Windows Vista, Windows XP, Windows ME, Windows 2000. Attack on the device or disk storage system including the MS Excel related data files and folders by malware or virus.Failure to read or write from a file or trying to get access to an object that does not exist.Error in a macro or the macro that you are trying to run is corrupt.Microsoft Excel-connected files maliciously or wrongly deleted by another program.Windows system files or Microsoft Excel-related program files infected by malware or a virus.

Infected download or deficient installation of Microsoft Excel software.

Vba excel 2013 free download