View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Allen Ben Allen is offline
external usenet poster
 
Posts: 21
Default Multiply All values by a cell

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!"