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
Bookmarks