View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Atishoo Atishoo is offline
external usenet poster
 
Posts: 267
Default 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