Hi Ben,.

Something like

For Each cell In Worksheets("Sheet1").Range("C1:H10")
cell.Value = cell.Value * Worksheets("Sheet2").Range("F2").Value
Next cell

adjust to suit

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ben Allen" wrote in message
...
I have a table filled with values that are formated by currency. I need to
multiply each of these values (all in columns G to K) by a value on
another
sheet which contains the latest exchange rate.I want this to happen in a
macro when a button is clicked.
Thanks for any help.
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"