maaf pak zainul, untuk vb copy nya belum berfungsi. vb hya berjalan pada vb searchnya aja.... mungkin bisa dbantu lebih lanjut pak zainul. terima kasih
2012/1/25 zainul_ulum <[email protected]> > > maaf salah dikit, kurang syntax selection didepan .find > > Sub cFindID() > Dim Search As String > On Error GoTo ErrorCatch > > Search = Range("E5").Value > Sheets("dBASE").Select > Range("T15:T5014").Select > 'Selection.Find(What:=Search, After:=ActiveCell, LookIn:=xlValues, _ > 'LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ > 'MatchCase:=False, SearchFormat:=False).Activate > > Set c = Selection.Find(Search, LookIn:=xlValues, SearchOrder:=xlByColumns) > > If Not c Is Nothing Then exit sub > c.copy > > 'Range("T508").Select > 'Selection.Copy > Sheets("F-INPUT").Select > Range("AD5").Select > Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks > _ > :=False, Transpose:=False > Application.CutCopyMode = False > Exit Sub > > ErrorCatch: > MsgBox "ga nemuken..?!" > > End Sub ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------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: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
