lajar-excel@yahoogroups.com
> *Cc:* Harry
> *Dikirim:* Selasa, 11 Juni 2013 23:05
> *Judul:* Re: [belajar-excel] UserForm Print (dengan syarat & kondisi)
>
> ngga ngerti bahasa VBA, tak coba pakai bahasa logika sederhana saja
> sesuai kemampuan daku aja ya
>
> /Private Sub C
Coba event click pada tombol print diisi dengan script :
Dim rng As Range, rngData As Range
Application.ScreenUpdating = False
Set rngData = ORDERPPA2.Range("d8:d22,d25:d39")
For Each rng In rngData
If LenB(rng.Value) = 0 Then
rng.EntireRow.Hidden = True
ngga ngerti bahasa VBA, tak coba pakai bahasa logika sederhana saja
sesuai kemampuan daku aja ya
/Private Sub Cmdcetak_Click()//
/
/Dim i, iMakanan, iMinuman As Integer, Cur As String/
/Cur = ActiveCell.Address/
/With ORDERPPA2/
/i = 8: While Not IsEmpty(.Cells(i
3 matches
Mail list logo