如何将excel clmn值转换为int，并与其他clmn变量一起重新添加它们并将其存储在excel中

Question

dim g as int, i as string
range("a1").value = i 
g = 10
range("b1").value = i + g 

设A1 =1预期B1 = 11但它是10

Answer 1

dim g as int, i as string
i = range("a1").value 'assuming that A1 contains 1
g = 10
range("b1").value = i + g 

二线作业是错误的。

机翼

Answer 2

因为我是字符串 var ("1")，所以它应该是..

range("b1").value = val(i) + g