View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David Adamson[_4_] David Adamson[_4_] is offline
external usenet poster
 
Posts: 61
Default Invalid Procedure

The origninal developer sounds as bad as me.

The problem is that the developer probably didn't declare all the varaibles
that were used.

It is something that I have learn't the hard way.

Make sure all variables are declared properly (use the "option explicit") to
help you.

Once in the VBE window use "Tools", "Options", "Editor", "Require Varaible
Declaration".




"kldempsey " wrote in message
...
I've recently taken over macros and the person's machine they were
developed on works great, however when I try to run the macros on my
machine or someone elses I get an invalid procedure on the InsertLines
command. This code works fine on the developers machine. I checked
the tools-references and we're using the same dlls as far as I can
tell. We are in a common desktop environment. Where else can I
compare our machine's setup? Thanks for any ideas!


---
Message posted from http://www.ExcelForum.com/