<BTW, What trouble?

Once only:

ToolsOptionsClick "Require Variable declaration".

It will insert the Option Explicit line autoamtically

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message
...
You should'nt have told him what the typo was, Peter :-}

<sometimes it doesn't seem worth the trouble

OK. You had a problem. You probably (hopefully) spent some effort trying
to solve it.
You took the trouble to post a message. Several people (no idea how many)
tried to reconstruct your problem.
Some answered.

Now what do you think about <sometimes it doesn't seem worth the trouble

It's ALWAYS worth the trouble. BTW, What trouble?

I think there's no excuse for not using Option Explicit.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Peter T" <peter_t@discussions wrote in message
...
Niek cited your own routine as a perfect example of why you should always
use Option Explicit

In case you still haven't seen it, you have

"difference" and "dfference"

(I haven't looked to see if there are other errors too)

Regards,
Peter T

"imda14u" wrote in message
...
Niek Otten schreef:
Hi Sybolt

Always use Option Explicit

Now you allowed yourself a typo without VBE detecting it

If you correct it, you'll find another error, but that's a different
story


Niek,

thanks fot the reply,

I know about the option explicit statement, but sometimes it doesn't
seem worth the trouble.

Tell me about the different story.


:)

Sybolt