求助宏中变量的问题。。。。。。

[zhangzhaoh]

大家好，请教一个问题，我在宏中定义了一个变量sheetname

想用这个sheetname 修改对应的表单里的值，可是在入面的语句中出现

“子过程或函数未定义”，它把Worksheets(fsheetname)看成函数了，这应怎么改呢？？？


For i = 1 To 20 Step 1

Worksheets(sheetname).Rows(i).Insert
Worksheet(sheetname).Cells(i, 1) = "A"

Next

[cpio]

Application.Sheets(sheetname).Cells(i, 1) = "A"

[zhangzhaoh]

谢了，我解决了，少了一个s
Worksheet(sheetname).Cells(i, 1) = "A"
改为
Worksheets(sheetname).Cells(i, 1) = "A"