excel vba multiply cell value

The solution for “excel vba multiply cell value” can be found here. The following code will assist you in solving the problem.

Sub Multiply_a_range_of_cells_by_same_number()
‘declare variables
Dim ws As Worksheet
Dim rng As Range
Dim myVal As Range
Set ws = Worksheets(“Analysis”)
Set rng = ws.Range(“B3:C7”)
For Each myVal In rng
myVal = myVal.Value * ws.Range(“E3”)
Next myVal

End Sub

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts