I never use Option Explicit. But there's no reason you shouldn't; you can turn it on, and include Dim statements for each variable mentioned in my code that doesn't already have one. Come to think of it, I think that's just wo.



You definitely should change the variable names to something that works for you. I like short names, so I've gotten used to meaningful abbreviations—"meaningful" in the sense that they mean something to me. But the important thing is that your program mean something to you.

But you ask for pointers to how to "do this"; you mean how to change the variable names? That's so easy that I'm doubtful it can be what you meant; you just write over them, just like editing an email. If "soFm" is nonsense to you and you want to use "SourceWSheet" instead, just write "SourceWSheet" wherever the original code uses "soFm". Or use the VBA Editor's Find/Replace function.

But as I said, that's so simple that it can't be what you were asking...?

I managed to solve my own question! I was trying to over complicate things. Thanks for all your help.
Liz

Not using Option Explicit is a disaster waiting to happen. Without it, you can end up with all sorts of strange run-time errors due to mistyped variables. I don't know of a single professional coder who doesn't use it.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]