Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

UPDATING 1

Status
Not open for further replies.

gc1234

Programmer
Mar 4, 2004
94
GB
Yep, me again

whats wrong with this, I want to update the cell with its current contents plus value from another cell

Worksheets("Sheet2").Cells(Row, RanOnceCol).Value = Worksheets("Sheet2").Cells(Row, RanOnceCol).Value + Add.Cells(InRow, 1).Value
 
Hi,

Add is a reserved word AND it is not an object for Cells
]code]
Worksheets("Sheet2").Cells(Row, RanOnceCol).Value = Worksheets("Sheet2").Cells(Row, RanOnceCol).Value + Cells(InRow, 1).Value
[/code
:)

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top