Simple add function not working! Missing something [SOLVED]

[FranktheBank]

Hello all,

Simple problem here's the Code

Worksheets("Finance").Cells(lng2, 3) = Worksheets("Finance").Cells(lng2, 3).Value + Worksheets(RC_Name).Cells(lngI, 3).Value

Run Time Error: 13
It's not adding? 'Add Watch' has error <Type mismatch> Variant/Integer.

I'm trying to add multiple values from Worksheets(RC_Names).Cells(lngI,2)value, where as "RC_Names" & "lngI" are variables and change

I've also tried

 Worksheets("Finance").Cells(lng2, 3).Value = Worksheets("Finance").Cells(lng2, 3).Value + Worksheets(RC_Name).Cells(lngI, 3).Value

to no avail.

Is this enough for someone to tell me what I'm doing wrong??

Thanks

 

[FranktheBank]

Never mind IO problem