[attach]39848[/attach] 我发上来的是我们这里的文化户口册,在打印时需要一户打印在一页上,我想每页设成15行,请高手帮帮忙为谢!
用下面这段代码就可以了
Sub 打印()
Dim x As Integer
Dim myRange As Range
Dim myUnion As Range
Dim c As Range
On Error Resume Next
Sheets("文化户口册 ").Select
irow1 = Sheets("文化户口册 ").[b65536].End(xlUp).Row
For i = 1 To irow1 Step 1
If Sheets("文化户口册 ").Cells(i, 2) = "户主" Then
y = i - 14
Set myRange = Range(Cells(y, 2), Cells(i - 1, 2))
myRange.Activate
Set c = myRange.Find(What:="户主", LookIn:=xlFormulas)
c.Activate
x = c.Row
Z = i + (14 - (i - x))
If i - x < 15 Then
我想应该可以用VBA代码实现,因为数据量很大,全镇有将近一万户.如果用手工排要两天才能排完.请高手指教作者: zxyhyuan 时间: 2009-10-9 14:32
请高手检查一下这段代码,错在什么地方,谢谢Sub 文化户口册打印()
Dim x As Integer
Dim y As Integer