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

<div>-------- Original message --------</div><div>From: "'M.Ade Alfarid' 
[email protected] [belajar-excel]" <[email protected]> 
</div><div>Date:08/01/2015  19:05  (GMT+07:00) </div><div>To: 
[email protected] </div><div>Subject: [belajar-excel] Macro pilih 
allsheet kecuali satu sheet [1 Attachment] </div><div>
</div>Dear,

Bagaimana macro memilih all worksheet kecuali satu atau lebih?

Ade

--

Kirim email ke