Dear pakar macro,
Gimana caranya menkondisikan baris perintah berikut agar tidak timbul
error jika dari cell yang aktif tidak ditemukan yang dimaui, baik itu
karena cell kosong atau tidak ada karakter “;”?
strCurrent = OrderTable(EdRecNo, 17)
i = Application.WorksheetFunction.Find(";", strCurrent)
strReplaced =
Application.WorksheetFunction.Replace(Arg1:=strCurrent, Arg2:=1,
Arg3:=i, Arg4:="")
TxtRemark = Application.WorksheetFunction.Trim(strReplaced)
-zam-
------------------------------------
bergabung ke milis (subscribe)
kirim mail kosong ke: [email protected]
posting ke milis
kirim kan ke: [email protected]
berkunjung ke web milis:
http://groups.yahoo.com/group/belajar-excel/
melihat file archive / mendownload lampiran
http://www.mail-archive.com/[email protected]/
menhubungi moderators & owners:
[email protected]
keluar dari milis (unsubscribe)
kirim mail kosong ke: [email protected]
ExcelWeb <http://opi.110mb.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:
[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/
