Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I get a type mismatch with the first code and still doesnt run with second,
clearly missing something, help is much appreciated with worksheets("sheet1") If Application.match(.Cells(i, 2), wipwkbk.Worksheets("Live").Range("b1:b18"), 0) 0 Then .Cells(i, 1).EntireRow.Copy Destination:=Worksheets("Sheet7").Cells(j,1) OR with worksheets("sheet1") If Application.match(.Cells(i, 2), wipwkbk.Worksheets("Live").Range("b1:b18"), 0) Then .Cells(i, 1).EntireRow.Copy Destination:=Worksheets("Sheet7").Cells(j,1) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Type Mismatch | Excel Worksheet Functions | |||
Type Mismatch | Excel Programming | |||
Type mismatch | Excel Programming | |||
Type Mismatch | Excel Programming |