How to increase all values in my spreadsheet by 10% automatically
You could run a sub:
For Each C In Worksheets("sheet1").Range("A1:Z1000")
If C.Value < "" Then
C.Value = C.Value + C.Value / 10
End If
Next
"Errol" wrote:
If I have entered in all my values and formulas into a worksheet and I want
to increase all these values by 10%, how do I go about doing this?
Cheers
|