Re: [belajar-excel] Delete Hidden Names dengan VBA

2017-06-11 Terurut Topik 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
Hai mas Zainul, Sebelum di delete, di-visible-ken lebih dulu saja. Regards, Kid 2017-06-10 6:10 GMT+07:00 Zainul Ulum zainul_u...@yahoo.com [belajar-excel] : > > > Be-Excelers, > File excel terlampir, terdiri dari dari 4 (empat) named range berupa > object tabel jika dilihat melalui [Name

Re: [belajar-excel] Delete Hidden Names dengan VBA

2017-06-09 Terurut Topik Zainul Ulum zainul_u...@yahoo.com [belajar-excel]
#dikirim_pakai_mail.yahoo.com_tanpa_pulsa# On Sat, 10/6/17, Zainul Ulum zainul_u...@yahoo.com [belajar-excel] wrote: Subject: [belajar-excel] Delete Hidden Names dengan VBA [1 Attachment] To: belajar-excel@yahoogroups.com Date: Saturday, 10

[belajar-excel] Delete Hidden Names dengan VBA [1 Attachment]

2017-06-09 Terurut Topik Zainul Ulum zainul_u...@yahoo.com [belajar-excel]
Be-Excelers, File excel terlampir, terdiri dari dari 4 (empat) named range berupa object tabel jika dilihat melalui [Name Manager]. Tetapi jika saya jalankan vba code berikut: '== Sub ShowAllNames() Dim n For Each n In ActiveWorkbook.Names n.Visible = True Next End Sub