Private Sub Workbook_BeforePrint(Cancel As Boolean)
End Sub
使用道具 举报
老师,怎么不行呢?
Private Sub Workbook_BeforePrint(Cancel As Boolean)With Sheet2 i = .[A65536].End(xlUp).Row + 1 .Cells(i, 1) = Cells(4, 4) .Cells(i, 2) = Cells(8, 5) End With
End Sub我的表2里没有进行数据填充。为什么呢?错在哪里?
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-16 23:39 , Processed in 0.259730 second(s), 8 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.