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?
Thx
Habiler
Code
Sub T()
'declare variables
Dim ws As Worksheet: Set ws = Worksheets("EchellesIndexed")
'Dim rng As Range: Set rng = ws.Range("c2 : bv104")
'Dim rng As Range: Set rng = ws.Range("c2 : c104")
'Dim rng As Range: Set rng = ws.Range("c2:C104", "c2:bv104")
Dim toCalc As Range
For Each toCalc In Range("c2:C104").Cells
toCalc = toCalc * 2
Next toCalc
End Sub
