求高手将复杂的公式改为代码~~~~

KCFONG · 发表于 2013-4-7 15:36

column F, I and S,W columns ???

Bjj199299 · 发表于 2013-4-7 15:40

KCFONG 发表于 2013-4-7 15:36
column F, I and S,W columns ???

W and i

Bjj199299 · 发表于 2013-4-7 16:14

Bjj199299 发表于 2013-4-7 15:40
W and i

顺便问下!这段代码什么意思?
dic2(W) = dic2(W) + Rng(R, 15)

Bjj199299 · 发表于 2013-4-7 16:33

KCFONG 发表于 2013-4-7 15:36
column F, I and S,W columns ???

maybe there was some problem in this code"dic2(W) = dic2(W) + Rng(R, 15)"!
because the value of dic2(w) was always empty

Bjj199299 · 发表于 2013-4-7 17:28

KCFONG 发表于 2013-4-7 15:36
column F, I and S,W columns ???

this workbook was very important to me !please help me！
i'm so anxious........

KCFONG · 发表于 2013-4-7 18:22

I can read chinese,
you can use chinese,
i just go out , don't hurry.
i will help you
but you must give me some example,
and tell me clearly, which cell is wrong, and what the result should be.

Bjj199299 · 发表于 2013-4-7 18:44

KCFONG 发表于 2013-4-7 18:22
I can read chinese,
you can use chinese,
i just go out , don't hurry.

你上传的附件计算完全符合我的要求...但是不知道为什么在我的电脑上两列日期正常..但是i和w列却是空的...

Bjj199299 · 发表于 2013-4-7 20:27

本帖最后由 Bjj199299 于 2013-4-7 20:30 编辑

KCFONG 发表于 2013-4-7 18:22
I can read chinese,
you can use chinese,
i just go out , don't hurry.

上传了一份我删除4列数据后重新运行代码得出的结果！蓝色箭头所指的两列全是空的！
为什么同样的代码运算出来的就是2种结果呀~我的VB版本是6.5~Office版本是2007~系统是Win8~你看看会不会是因为我电脑的问题呀？
现在的问题就是~你上传的附件运算好的结果~完全符合我的要求，但是我的电脑却无法运算

KCFONG · 发表于 2013-4-7 21:56

you mean I4 and w4 ??
客户编号 is A-001
and no record of A-001 in file 312.xls ??? so no result is correct
please check

Bjj199299 · 发表于 2013-4-7 21:56

KCFONG 发表于 2013-4-7 18:22
I can read chinese,
you can use chinese,
i just go out , don't hurry.

大侠~这个表格真的很急~我在线等！多谢啦！

		自动登录	找回密码
密码			免费注册

[已解决] 求高手将复杂的公式改为代码~~~~