sub or function not defined

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dan - 26 Jan 2006 10:57 GMT

Hi - can anyone help me please.

I have recorded / (and slightly written) some simple macros to search
through a document and pull out data I'm interested in however when I run the
macro I get "Sub or function not defined" messages. They then run correctly
despite this - can anyone lead me on the path to what I can look at to stop
these messages popping up. The code still works but I have to keep ok-ing
the messages rather than letting it run right through.

Reply to this Message

Graham Mayor - 26 Jan 2006 12:49 GMT

It might help if you pasted your code into your message. Crystal balls are
not what they were :(

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi - can anyone help me please.
>
[quoted text clipped - 5 lines]
> works but I have to keep ok-ing the messages rather than letting it
> run right through.

Reply to this Message

Kevin B - 26 Jan 2006 14:10 GMT

Open the VBA editor (Alt + F11) and arrange the Windows so you can see the
document as well as your VBA editor. The locate the cursor somewhere in
your macro and then press F8 to step through the macro one command at a time.
This will help you locate the line where the error is occurring.

It sounds like a typo to me.

Signature

Kevin Backmann

> Hi - can anyone help me please.
>
[quoted text clipped - 4 lines]
> these messages popping up. The code still works but I have to keep ok-ing
> the messages rather than letting it run right through.

Reply to this Message