Hello,

I am a little stuck on why this won't work. I copied values from one sheet to another. Now, on the new sheet, I'd like to multiply one particular column by 1000. However, the multiplication is not updating.

Private Sub GetRawData_Click()
  
 With Sheets("Raw Data")
    .Range("A11", .Range("A" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("A12")
    .Range("B11", .Range("B" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("B12")
    .Range("E11", .Range("E" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("C12")
    .Range("F11", .Range("F" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("D12")
    .Range("H11", .Range("H" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("E12")
    
    End With

    Dim i As Integer
    Dim c As Integer
    
    i = Application.CountA(Range("B12"))
    
    For c = 12 To i
        Cells(c, B) = Cells(c, B) * 1000
    Next c
  
  
End Sub