Performing a calculation on a range of cells and replacing contents

[Crazy_Ivan]

So I would like to select a range of cells or a single cell and perform a calculation on each individual cell and replace the contents of each individual cell with the outcome of the calculation.

The calculation will always be MULTIPLY BY 0.38444%

So for example, I select A1:D12, run the macro through a shortcut, then the original numbers in the range selected are all multiplied by 0.38444% and the answers, pasted as a value (or =original value * 0.38444%) fill each cell in the range.

Feels like a simple question.... is there a simple answer?!

Thanks!

 

[Fluff]

Put the 0.3844 into a cell, copy it & then select the cells to multiply & paste special multiply.

 

[Fluff]

If you need a macro select the cells you want to multiply & use

Sub CrazyIvan()
   With Selection
      .Value = Evaluate("if(" & .Address & "="""",""""," & .Address & "*0.0038444)")
   End With
End Sub

This will only work on a contiguous range.

 

[Crazy_Ivan]

If you need a macro select the cells you want to multiply & use

Sub CrazyIvan()
   With Selection
      .Value = Evaluate("if(" & .Address & "="""",""""," & .Address & "*0.0038444)")
   End With
End Sub

This will only work on a contiguous range.

Ah perfect - the macro is just what I need.
It is shortcut so I can see a KPI very quickly in different data sets.

Thanks for your help!

 

[Fluff]

You're welcome & thanks for the feedback.