CODE berisi langkah2 program yang akan dilakukan...
Sent from Samsung Mobile <div>-------- Original message --------</div><div>From: "'M.Ade Alfarid' [email protected] [belajar-excel]" <[email protected]> </div><div>Date:08/01/2015 19:49 (GMT+07:00) </div><div>To: [email protected] </div><div>Subject: Re: [belajar-excel] Macro pilih allsheet kecuali satu sheet </div><div> </div>Kok compile error, ya Pak HK? Private Sub kecuali_satu() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets If wks.Name <> "1" Or wks.Name <> "2" Then code.... End If Next wks End Sub Salam,Ade On Thu, 08 Jan 2015 20:05:33 +0700, Hendrik Karnadi [email protected] [belajar-excel] <[email protected]> wrote: Hai Ade, Coba begini...(milihnya satu2 pake looping) Dim wks as worksheet For each wks in thisworkbook.worksheets If wks .name <> "x" or wks.name <> "y" then CODE.... End If Next wks Salam, HK Sent from Samsung Mobile -------- Original message -------- From: "'M.Ade Alfarid' [email protected] [belajar-excel]" Date:08/01/2015 19:05 (GMT+07:00) To: [email protected] Subject: [belajar-excel] Macro pilih allsheet kecuali satu sheet [1 Attachment] Dear, Bagaimana macro memilih all worksheet kecuali satu atau lebih? Ade -- --
