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]:
[belajar-excel] Macro pilih allsheet kecuali satu sheet [1 Attachment]
Dear,
Bagaimana macro memilih all worksheet kecuali satu atau lebih?
Ade
--
--
