I still receive "compile" errors. I guess I just don't
understand how it all works. Thanks for trying but I
guess I just don't get it. Oh, well.
Dan

-----Original Message-----

Replace your actual values with variables.

Get a value to your variables BEFORE the line of code
that
needs it.

To get the value use someting like ;

FromZip = 0'to re-set the value
ToZip = 0'to re-set the value

FromZip=range("A1").value
ToZip=range("B1").value

and your code that needs the from and to values .....
.