Without knowing what the calculation is supposed to return, the code would be anyone's guess. As it is, it looks like the value in pounds in column D should be the amount in column c * 3.65. You don't really need a macro for that!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|