注册 登录
编程论坛 VB6论坛

输入的文本不是效的引用或已定义的名称哪位大神帮我看看急!

zhaoyin 发布于 2022-03-26 22:21, 1504 次点击
只有本站会员才能查看附件,请 登录

Sub 收尾汇总()

'定义一个储存行号的变量
Dim num

'使用Cells.Find获取的行号赋值给num
num = Cells.Find(what:="*", after:=Range("a1"), searchorder:=xlRows, searchdirection:=xlPrevious).Row
'输出num,也就是得到的行号
'MsgBox num + 1

Cells(num + 2, 1) = "护栏合计:" & Cells(5, 11) & "条"

'Cells(num + 2, 3) = Cells(5, 11) & "条"

Cells(num + 2, 4) = "总计应付:" & Cells(6, 11) & "元"

Cells(num + 2, 7) = "客户签名:"

'Cells(num + 3, 1) = "合计:" & Cells(6, 12) & "元整"

Cells(num + 3, 1) = " 备注:客户收到货后对数量,单价,质量有异议,请于七天内通知本公司解决,否则恕不承担任何后果。"


ActiveSheet.PageSetup.PrintArea = Cells(1, 1).Resize(num + 3, 4) 'Range(Cells(1, 1), Cells(d, 8))

End Sub
1 回复
#2
zhaoyin2022-03-27 09:33
ActiveSheet.PageSetup.PrintArea = Range(Cells(1, 1), Cells(num + 4, 8)).Address
后面加上那个.address就可以了,谢谢CSDN的weixin_30832983
1