请教 VBA f = Range(b b = defds123 f

显示全部楼层 · 2011-10-15 12:35:29

F=defds1232defds1232defds1231defds1232defds1231defds1231defds1232defds1231defds1232defds1232defds1231defds1231defds1232defds1231defds1231defds1232defds1231defds1231defds1232defds1232defds1231defds1232defds1232defds1232defds1231defds1231defds1232defds1232运行提示1004错误

千问 · 2011-10-15 12:35:29

喔，公式错误。第二句是等同于输入公式，结果公式不正确所致。改一下，Range(\"b\"defds123finalrow17)单元格输入“2defds1232defds1231defds1232defds1231defds1231defds1232defds1231defds1232defds1232defds1231defds1231defds1232defds1231defds1231defds1232defds1231defds1231defds1232defds1232defds1231defds1232defds1232defds1232defds1231defds1231defds1232defds1232”即可，既去掉字符串第一个“defds123”字符。