Ysh: Pak Kid, Pak Anton, Mbak Siti & group member sadayana... Tarema kaseh... kiriman UDF nya yg hebat-hebat... Semuanya langsung berguna di lapangan, dan berguna untuk bahan pelajaran : hao tu mik an YU-DI-EPF
*[belajar excel] top markotop ! *gitu loch...!! HerrSoe 2010/5/17 anton suryadi > Function Insret(t As Range, x As String, Optional y As String = "") As String > >semoga bermanfaat > ________________________________ > From: Mr. Kid > Sent: Sun, May 16, 2010 2:39:45 AM > Dulu pernah buat penyusun pattern id seperti begini : > Public Function SetPatternBase( sText As String, lPanjang As Long, _ > Optional sSisip As String = "|") As String >----------------------------------- >> 2010/5/15 siti Vi <setiyowati.devi@ gmail.com> >> Daripada "pusing formula" (atau cell formatting?? ) pakai UDF aja dech ya.... >> Function InsertChar(Xel As Range, N As Byte, _ >> Optional Separator As String = ",") As String _______________________ >> ----- Original Message ----- >> From: HerrSoe >> Sent: Friday, May 14, 2010 11:01 PM >> Bagaimanakah cara termudah untuk memberi KOMA tiap 5 karakter >> dihitung dari kanan; contohnya seperti ini >> 10000023456789012345 00000,12345, 67890,12345 >> 0001230004560007890 00321000 00,01230,00456, 00078,90003, 21000