Dear all master... Kiranya bisa di terjemahkan ke bhs manusia code macro sebagai berikut :
Sub macro2() ActiveSheet.Range(”$V$7:$W$564”) .AutoFilter Field:=1, Criteria1:=”<>” ActiveWindow.SmallScroll Down:=-6 End sub Mohon pencerhannya yah.. Trims. Hafidz Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT ------------------------------------ ------------------------------------ ===================================================================== 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-subscr...@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-ow...@yahoogroups.com keluar dari membership milis (UnSubscribe): kirim mail kosong ke belajar-excel-unsubscr...@yahoogroups.com --------------------------------------------------------------------- ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: belajar-excel-dig...@yahoogroups.com belajar-excel-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: belajar-excel-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/