View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Graham McNeill Graham McNeill is offline
external usenet poster
 
Posts: 1
Default Convert values in a variant array to integer values

I wish to add up certain values in a variant array (has to be variant, as
data is mixed), to make sure total of these values does not exceed 100. I
thought I could simply assign these array values to integer variables and
that would work, but it concatenates the numbers (12 + 4 = 124, for
instance) instead of adding them.

Any ideas how to do this?