Question

用VB修改EXCEL中单元格的值

代码如下
······
Dim x3 As Excel.Worksheet
······
x3.Cells(i, j) = 10 * i + j
系统提示错误：
Expression is a value and therefore cannot be the target of an assignment
在网上找到的资料都是这么写的，为啥我的就不行呢

Answer 1

改成：
x3.Cells(i, j).value = 10 * i + j

Answer 2

试试这样写：x3.cells(i,j).value=10*i+j

Answer 3

有没有set x3 = thisworkbook.worksheets(1)给x3赋值？