Pak Kid. Terima kasih sudah bisa sudah di temukan masalahnya , dan sudah di perbaiki.
salam Lukman 2014-10-15 13:35 GMT+07:00 'Mr. Kid' [email protected] [belajar-excel] < [email protected]>: > > > Coba disempatkan mencermati datatype, seperti yang ada disini > <http://b-excel.blogspot.com/2013/07/belajarvba-004-tipe-data-variabel.html> > . > > 2014-10-15 16:55 GMT+11:00 lkm jktind [email protected] [belajar-excel] > <[email protected]>: > > >> >> Tanya : >> 1. berapa banyak Dim yg bisa di gunakan dalam 1 modul ? >> 2. mengapa saya di haruskan menambah dim yg tidak saya perlukan ? >> >> contoh : >> Sub Lk_01() >> Dim wb1, wb2, wb3 As Workbook >> Dim sh1, sh2, sh3 As Worksheet >> Dim Lk_r, Lk_c As Long >> Dim tic, tic_acc, quater, data As Range >> Dim path, flnm, ban1 As Variant >> Dim dbl As Double >> Dim r, c, qq, q1, q4, qy, qtr As Long >> Dim aa1, ticker As String >> Dim aa2, ba2, aa3, ba3, aa4, aa6, ba6, aa7, aa8, ab88, kurs As Double >> Dim ae1, be1, be1q1, be1q4, be1qy, be1qq, as1 As Double >> Dim ae3, be3, be3q1, be3q4, be3qy, be3qq, as2 As Double >> Dim ae5, be5, be5q1, be5q4, be5qy, be5qq, as3 As Double >> Dim ag5, bg5, bg5q1, bg5q4, bg5qy, bg5qq, as4 As Double >> Dim ae4, ae6, ae7, ae8, ae9, at100 As Double >> Dim ag2, ag6 As Double >> Dim baq1, baq4, baqy, ban4 As Variant >> >> seperti : as1, as2, as3, dan as4 bila tidak ada . maka be1qq , be3qq , >> be5qq, bg5qq akan menjadi error . >> >> Salam >> >> Lukman >> >> >> > >
