worksheet calculation

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top