Hi
I have completed a tool that allows for raw reports to be formatted. I now need the contents of the selection to be multiplied by a value.
What is the best way to do this in VBA?
My selection is Worksheets(1).Range("A1:A50")
Need to mulitply it by the value of 'FX' but have the answer rounded to 4 decimal places....