| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Else no If
Try the true branch in a separate line:
If LC2 = 0 Then GoTo SKIP Else Sheets("Estimated - BA Approved").Select Range("A3").Select DC2 = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row Sheets("QueryResultsExcel 1 ").Select Range("A3:R" & LC2).Select Selection.Copy Sheets("Estimated - BA Approved").Select Range("A" & DC2).Select ActiveSheet.Paste End If SKIP: Regards, Stefi |
Threaded Mode
