[belajar-excel] Digest Number 4153

Milis Belajar Microsoft Excel Group

1 Message

Digest #4153

1a

Re: Menyembunyikan kolom berdasarkan semester dan jenjang [1 Attachm by "nangagus"

Message

1a

Re: Menyembunyikan kolom berdasarkan semester dan jenjang [1 Attachm

Mon Apr 10, 2017 12:30 am (PDT) . Posted by:

"nangagus"

Barang kali begini:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells = Range("C2") Then
Rows("9:41").Hidden = False
If Range("C2") = "I" Then Rows("25:40").Hidden = True
If Range("C2") = "II" Then Rows("10:24").Hidden = True
End If
End Sub

Private Sub Worksheet_Activate()
Columns("A:N").Hidden = False
If Sheet1.Range("C6") = "MI" Then
Columns("F:M").Hidden = True
If Sheet1.Range("C2") = "I" Then Columns("D:E").Hidden = True
If Sheet1.Range("C2") = "II" Then Columns("B:C").Hidden = True
End If
If Sheet1.Range("C6") = "MTS" Then
Columns("J:M").Hidden = True
Columns("B:E").Hidden = True
If Sheet1.Range("C2") = "I" Then Columns("H:I").Hidden = True
If Sheet1.Range("C2") = "II" Then Columns("F:G").Hidden = True
End If
End Sub

On 07/04/2017 6:19, farud oke farud.oke@gmail.com [belajar-excel] wrote:
>
> Mohon bantuan para master excel dengan persoalan yg saya hadapi,file
> terlampir
> Atas bantuannya saya ucapkan terima kasih
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use