Multiply all cell from multiple range

  • Hello, I try to multiply each cell of (C2:BV104) by an X number. Only the first column or row is calculated.

    Who can help me please?



    Edited once, last by habiler ().

  • For me work this:

    Sub T()
    Dim ws As Worksheet: Set ws = Worksheets("EchellesIndexed")
    Dim rng As Range: Set rng = ws.Range("c2:bv104")
    Dim toCalc As Range
    For Each toCalc In Range("c2:bv104").Cells
    toCalc = toCalc * 2
    Next toCalc
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!