hi all, i want to ask
i make a vb at excel 2007
Worksheets("Dalam").Activate
Dim sht As Worksheet, look As Worksheet
Dim coldlm As Integer, rowdlm As Integer, no As Integer, sheet As Integer, ow As Integer, rowkm As Integer, hap As Integer, hip As Integer
Dim kg As Range, kgg As Range, oww As Double
Dim own
For ow = 4 To 1243 Step 7
If ow > 11 Then
Worksheets("Dalam").Range("I11:BB16").Copy _
Destination:=Worksheets("Dalam").Cells(ow, 9)
End If
no = Worksheets("Dalam").Cells(ow, 10)
sheet = no - 68
For coldlm = 19 To 24
For rowdlm = 1 To 6
wewq = (Int(rowdlm) + Int(ow) - 1)
oww = hap / 7
own = Int(oww)
rowkm = ow - own * 7
Set kg = Sheets(sheet).Cells(rowkm, coldlm)
If kg > 0.0000001 Then
Set kgg = Worksheets("Dalam").Cells(rowdlm, coldlm)
kgg = kg
End If
Next
Next
Next
i want to make the second line red font into oww = wewq / 7
but everytime i try to oww = wewq / 7 i got error '1004' message
if i don't put wewq at second line, the programs run, but oww = 0, i want
oww = ( rowdlm + ow -1 )
thanks
Bookmarks