I have two columns in a worksheet, one for £ and one for $.
There maybe a value both columns or in just one of the two.
If there is a valu in each column, I want to leave them alone, but
where there is a value in the $ column but not in the £ column I want
to apply a rate (say 1.7) and vice versa.
So I _dont__want a function in column b to say =A1*1.7 as that will be
applied to all values.
The range that the code should be applied to is A3:end of columns and
B3:end of columns (to allow for headings).
Is it possible to do this in code??

The Function works but changes some values that were set at different
rates, and I dont want these changed.
Struggling a bit here, so any assistance would be great!


--
QuickLearner
------------------------------------------------------------------------
QuickLearner's Profile: http://www.excelforum.com/member.php...o&userid=35483
View this thread: http://www.excelforum.com/showthread...hreadid=559830