由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Windows版 - what's wrong with this VBA Excel code?
相关主题
VBA问题请教请教:如何找到或者删除excel中隐藏的表?
Re: [转载] 这里有没有excell高手啊,帮帮忙吧。excel: can not find under specified dir.
Re: 怎样在Excel里面做下拉菜单?Interfacing Microsoft Excel VBA with FORTRAN
如何将文本中的数据导入到exel?excel 求助
Re: Q: VBA in Excel转两篇相关主题的文档(1)
Excel 的问题VB code for extracting SWF from DOC/XLS
EXcel VBA helpRe: 一个关于excel的问题。
how to use global variable in excel VBAexcel VBA string process question
相关话题的讨论汇总
话题: value话题: cell话题: sub话题: next话题: integer
进入Windows版参与讨论
1 (共1页)
m******u
发帖数: 12400
1
Can't be compiled, won't work. Why?
...............................
Sub Add_spe()
Dim i As Integer
Dim j As Integer
For i = 2 To i = 5
For j = 2 To j = 6
Cell(i, j).Value = (Cell(i, 1).Value + Cell(1, j).Value)
Next j
Next i
End Sub
A*****a
发帖数: 52743
2
Cells(i,j).Value?

【在 m******u 的大作中提到】
: Can't be compiled, won't work. Why?
: ...............................
: Sub Add_spe()
: Dim i As Integer
: Dim j As Integer
: For i = 2 To i = 5
: For j = 2 To j = 6
: Cell(i, j).Value = (Cell(i, 1).Value + Cell(1, j).Value)
: Next j
: Next i

m******u
发帖数: 12400
3
right. corrected already.
1 (共1页)
进入Windows版参与讨论
相关主题
excel VBA string process questionRe: Q: VBA in Excel
如何用excel VBA求解median?Excel 的问题
excel VBA: create dir, move files under that dir.EXcel VBA help
vba in excel: calculate Modehow to use global variable in excel VBA
VBA问题请教请教:如何找到或者删除excel中隐藏的表?
Re: [转载] 这里有没有excell高手啊,帮帮忙吧。excel: can not find under specified dir.
Re: 怎样在Excel里面做下拉菜单?Interfacing Microsoft Excel VBA with FORTRAN
如何将文本中的数据导入到exel?excel 求助
相关话题的讨论汇总
话题: value话题: cell话题: sub话题: next话题: integer