Hello..
could anyone help me with this below macro?
whats wrong with it, i receive error massage for the red line
![]()
Dim i, k As Integer Dim N, B As String i = 1: k = 1 line1: If Workbooks("download.xls").Worksheets("Label List").Cells(i + 2, 5).Value = 0 Then MsgBox "Filtering finished" GoTo line2 Else If "N" = Left(Workbooks("download.xls").Worksheets("Label List").Cells(i + 2, 5), 1) Or "B" = Left(Workbooks("download.xls").Worksheets("Label List").Cells(i + 2, 5), 1) Then Workbooks("download.xls").Worksheets("Label List").Cells(i + 2, 1).Resize(1, 22).Copy Workbooks("label system_main control.xls").Worksheets("LGEIN").Cells(k + 2, 1).Paste k = k + 1 i = i + 1 GoTo line1 Else i = i + 1 GoTo line1 End If line2: End If End Sub
error massage:
-------------------------------------------------
Run-Time error '438'
Object doesn't support this method
-------------------------------------------------
thank you
juna-











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks