This has got to be easy, but no matter what I try I get a formula instead of a value. What I am trying to do is take the hours in column I and multiply times 60 to put the minutes in column C. So far have the following:
Sub ConvertMinutes()
Dim myRng As range
Dim lastRw As Long
'get the last row with an entry
lastRw = ActiveSheet.range("I2").End(xlDown).Row
With ActiveSheet.range("C2")
.Value = "=I2*60"
.AutoFill Destination:=ActiveSheet _
.range("C2:C" & lastRw&)
End With
End Sub
Any help is appreciated. LAS
Bookmarks