You can use:


ActiveWorkbook.Names.Add Name:="UK_Rate", RefersToR1C1:="=1.62"

and whanever the UK rate changes, change from 1.62 to the new rate.


you can use as well one array
check this sub:

Sub Macro3()
'(UK,Italy,Portugal, Chile, France, Spain,Germany...)
Dim Rates
Rates = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
'when a new value comes for "UK"
Rates(0) = 5
End Sub

if you know
rates(0) belong to "UK rate" when the new value comes
rates(0)=5, if 5 is the new valu

--
Message posted from http://www.ExcelForum.com