|
发表于 2014-2-11 00:05:11
|
显示全部楼层
'加入 去掉没有数据的行
Sub 按钮1_Click()
Dim SelectCol As Integer
Dim Str As String
Dim i As Long
SelectCol = Selection.Column
Columns("A:K").Hidden = True
Columns("D:D").Hidden = False
Columns(SelectCol).Hidden = False
Rows(1).Insert '在第1行前插入1行
Range("D1:J1").Merge
Cells(1, 4).HorizontalAlignment = xlCenter
Str = Cells(2, SelectCol)
Cells(1, 4) = Str
Cells(2, SelectCol) = "数量"
With Sheets("Sheet1")
For i = 2 To .[A65536].End(xlUp).Row
If .Cells(i, SelectCol).Value = "" Then
.Rows(i).EntireRow.Hidden = True
End If
Next i
End With
'Sheet1.PrintOut
Sheet1.PrintPreview
Cells(2, SelectCol) = Str
'Columns("A:K").Hidden = False
Sheets("Sheet1").Cells.EntireRow.Hidden = False
Rows(1).Delete
Cells(1, 1).Select
End Sub
|
|