View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Run-time error '5': Invalid Procedure Call or Argument

Don't you get thrown into the Visual Basic Editor at the statement
causing a problem by calling a nonexistent macro, function or addin.
Check the arguments your using when calling. If tyou have an optional
parameter you have to see optional in the subroutine's parameters.

did you try searching Google Groups:
Run-time error '5': Invalid Procedure Call or Argument group:*excel*

If you identify anything you about what was changed just before
the error started up and your version of Excel that might help.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nikila" wrote in message ...
Hello all!

Using Excel 2000 at work and periodically ("quite" periodically!) when I try
to save/exit I get the Run-time error above. Our Help Desk here at work
can't figure out what is wrong. Any ideas?

Thanks so much.....