View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
bruce taylor[_4_] bruce taylor[_4_] is offline
external usenet poster
 
Posts: 6
Default reading variable "from" and "to" ZIP codes


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 .....