View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] skulkrinbait@googlemail.com is offline
external usenet poster
 
Posts: 21
Default Simple addition problem

Hello, I've got this line of code:

iVarOutRight(iNumVar) = iVarOutCol(iNumVar) + iVarOutWidth(iNumVar)

Simple enough you'd have thought, but it's assuming the values are
strings when they are integers as it is concatenating them, for
example:

5 + 60 = 560

How do I get it to just add them up to give 65 as the result (for
example)?

Thanks!