M
Marita
Dear Julie,
I'm back again. I've adjusted your macro to:
Sub updatevalues()
Set myrange=Range("G3:G98")
For Each cell In myrange
cell.Value=cell.Value+cell.Offset(0,2).Value
cell.Offset(0,2).Value=""
Next
End Sub
When I used value of (0,1) it took info from column H and worked fine
But I need it from I. The value doesn't work with 2. What is it that
don't understand?
Thank you again,
Marit
I'm back again. I've adjusted your macro to:
Sub updatevalues()
Set myrange=Range("G3:G98")
For Each cell In myrange
cell.Value=cell.Value+cell.Offset(0,2).Value
cell.Offset(0,2).Value=""
Next
End Sub
When I used value of (0,1) it took info from column H and worked fine
But I need it from I. The value doesn't work with 2. What is it that
don't understand?
Thank you again,
Marit