How do you fix an Excel macro run-time error?

Answer by  Nelson39 (58)

After you exit out of the error window that is displayed, press Alt+F11. This will bring up the VBA code window. The name of the macro should be on the left Project area. Double-click on the macro. Press F5. The macro will stop on the error. Fix.

Answer by  ahsanmahmoodawan (1169)

use the following three statements on error ,resume and debug, the first one traps a runtime VBA error when it occurs , the second one tell you the application error

Answer by  worker673815 (25)

via tools - open the vb editor find the macro you created, set breakpoint on first line of code in procedure execute macro, see on which line the problem happens

Answer by  VB82 (32)

This error may be because Excel is trying to print something where nothing has been selected to print. May be you may be running a macro where nothing no work book is active.

Answer by  lgk (2426)

There is a patch for that on Micro Soft updates. Run the windows update to find and download it. Easy fix.

Answer by  hemantc (169)

You must first check that VB macro is right transferring to the defined rows in the excel worksheet.Do simple command usage to the system without leaving any small information.

Answer by  gigo (1706)

There can be several causes for that. It can happen if you work with drag and drop but the aim object you want to drop does not support that.

Answer by  nairjula (559)

If MS Excel 2000 edition standard version is in use, an error message will be displayed on the windows. It will read Run-time error '75' : Path/file - access error. You are done

Answer by  japratt (1687)

If you are getting this type of error you can do a few different things. The one things I would do it to reinstall the whole program to correct the problem.