Q: Multiplying in excel through vba I am new to vba programming, i want to create a programme that "how to copy n number of columns and rows from one excel sheet to another and multiply all the values from a given constant number"

A: Consider, as a model:
Sub demo()
    Dim r1 As Range, r2 As Range, C As Double
    C = 0.123
    Set r1 = Sheets("Sheet1").Range("A1:B9")
    Set r2 = Sheets("Sheet2").Range("A1:B9")

    r1.Copy r2

    For Each r In r2
        r.Value = C * r.Value
    Next r
End Sub

